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!
|