conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help exporting an Office 365 mailbox to PST 2
formatting excel date list 5
Comparison of columns using Conditional Formatting 3
Conditional Formatting 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
conditional formating with dates 1
Quday-Conditional Formatting 5
Conditional format refers to two cells 1

Back
Top