Excel 2007 Condition Formatting - Dates

  • Thread starter Thread starter Miskacee
  • Start date Start date
M

Miskacee

what is the formula to use to change the color of dates in a column ? I am
using conditional formatting. I have =today()+7 but that is not working.
Any suggestions?

Thank you very much!
 
Select the range of cells. Say Column A
Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
(if date is exactly same as today + 7)
=A1=TODAY()+7

(if greater than one week)
=A1>=TODAY()+7

Click the Format button
Select the desired style(s)
OK out



If this post helps click Yes
 
Back
Top