conditional formatting

R

rsdunphy

I have a spreadsheet that has dates in the columns. When the date is older
than 365 days, i need that cell highlighted red. Any help would be appreciated
 
J

JE McGimpsey

One way:

Choose Format/Conditional Formatting...

CF1: Formula is =(TODAY()-A1) > 365
Format1: <patterns>/Red
 
B

B. R.Ramachandran

Hi,

Select the column (e.g., A2:A1000), and under 'Format' -->'Conditional
Formatting', choose 'Formula Is' and enter the formula
=TODAY()-A2>365
and click 'Format' --> 'Patterns' and choose the red color for shading the
cell.

Regards,
B. R. Ramachandran
 
Top