find number < 60 and highlight Red

[jenn]

I have a column of dates B and a column of today's Date C; 10/04/04. I have
column d that subtracts B from C to give me a number. I want to find all
numbers in column C that are less than 60 and highlight them RED.... or
another formatting to make them stick out.

 

[Myrna Larson]

Use conditional formatting. You want Formula Is (instead of Cell Value Is),
and type the formula =D2<60, and set the format. I referred to cell D2. That
reference should be to whatever cell is active when you set up the formatting.