add color to certain cells after a date is shown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Have you tried using Conditional Formatting. You need to select all of the
cells as you are applying your conditional format.
 
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.
 
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
 
Back
Top