condition format based on lapsed dates

  • Thread starter Thread starter dave wagner
  • Start date Start date
D

dave wagner

I want to format a group of cell based on days old. The days is based on the
"value" in cell I8 =Now() and cell J10 (j11,j12...) on is the submission
date. Therefore number of days that has passed is in cell I10 (i11,i12...)
=$I$8-J10" in the cell, this is the number of days that has lapsed.

So if 90 days has passed I want to grey out cells k5,l5,m5, and n5. I am
unable to get this to work, what do I need to do to make this work?

I am assuming that the value is not showing correctly in the formula portion
of the conditional format: if cell(I10)>= 90 then [grey out cells
k5,l5,m5,n5]

Hopefully, someone can show me the way.

Thanks ahead for the help.

dave
 
After selecting the cells to be "greyed out". Select Conditional
Formatting from the Formatting menu,

Select Formula Is from the first drop down and enter =$I10>=90

Then select formatting.
 
Back
Top