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