View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Conditional Formatting with deadlines

Yes.

Select the cells you want to highlight
Click on Conditional Formatting on the HOME tab of the ribbon.
Choose Highlight Cell Rules
Choose a date occuring
Choose the condition and the format you want

or you may choose more rules and enter the condition you want

"figvm" wrote:

I have a simple spreadsheet with due dates. Is there a way to make the due
dates turn green when they are 2 days out from current date (Today) ? I have
office 2007.

Thank you!