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

One way:

Choose Format/Conditional Formatting...

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

In article ,
"rsdunphy" wrote:

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

Hi,

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

Regards,
B. R. Ramachandran

"rsdunphy" wrote:

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