ExcelBanter - conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - conditional formatting (https://www.excelbanter.com/excel-worksheet-functions/47616-conditional-formatting.html)

rsdunphy

conditional formatting

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

JE McGimpsey

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

B. R.Ramachandran

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

All times are GMT +1. The time now is 06:46 PM.