add color to certain cells after a date is shown
 

I am trying to set a color to a certain amount of cells after a date is
shown. I can get the cell that contains the date too but i cant get the rest
of the cells in that row too. any help in this would be much appreciated.

add color to certain cells after a date is shown
 

Have you tried using Conditional Formatting. You need to select all of the
cells as you are applying your conditional format.

"mobeer1958" wrote:

I am trying to set a color to a certain amount of cells after a date is
shown. I can get the cell that contains the date too but i cant get the rest
of the cells in that row too. any help in this would be much appreciated.

add color to certain cells after a date is shown
 

i have tried conditional formatting but not sure how to get it to work . I
have tried greater than 0 and i get the cells to hightlight up but I dont
want them to highlight till I enter a date. I'm not sure how to set up the
formula.

"Barb Reinhardt" wrote:

Have you tried using Conditional Formatting. You need to select all of the
cells as you are applying your conditional format.

"mobeer1958" wrote:

I am trying to set a color to a certain amount of cells after a date is
shown. I can get the cell that contains the date too but i cant get the rest
of the cells in that row too. any help in this would be much appreciated.

add color to certain cells after a date is shown
 

Let's say your date is in B5 and you want other cells in row 5 to be
highlighted when a date is entered.

Select the cells to highlight (you can select multiple rows if it applies)
Note which row you selected FIRST.
Format - Conditional Format
Formula is: =ISBLANK($B2)

The row # in the formula should be the first row you selected.

HTH,
Barb Reinhardt

"mobeer1958" wrote:

i have tried conditional formatting but not sure how to get it to work . I
have tried greater than 0 and i get the cells to hightlight up but I dont
want them to highlight till I enter a date. I'm not sure how to set up the
formula.

"Barb Reinhardt" wrote:

Have you tried using Conditional Formatting. You need to select all of the
cells as you are applying your conditional format.

"mobeer1958" wrote:

I am trying to set a color to a certain amount of cells after a date is
shown. I can get the cell that contains the date too but i cant get the rest
of the cells in that row too. any help in this would be much appreciated.