I can't figure out how to do in 2007 what I could do in 2003. I'm trying to fill cells a different color based on the age of the date in the cell. For example, it will fill yellow if it's 6 month old or older, and red if it's nine months old or older. However if the cell is blank, I don't want it to fill at all. Here is the formula I am currently using, please help: =(D1<=TODAY()-330)
Excel Excel 2007 Conditional Formatting
- Thread starter Picodillo
- Start date