color change in cells/group of cells

March 3, 2010 at 10:52:18
Specs: Windows XP
How can I have a cell change colors when it reaches a certain date. Example Cell A1 date 3/3/10.
When the calendar reaches 2/3/11, I want Cell A1 to change color

See More: color change in cells/group of cells

Report •

March 3, 2010 at 11:27:55
Try this

If the Date in Cell A1 equals Today’s date, this will get it to change colors.

1st Select cell A1

On the Menu Bar:

2nd Format
3rd Conditional Formatting
4th Change “Cell Value is” to “Formula Is”
5th Enter the formula:


Sub Menu Format :
6th Patterns
7th Choose a pretty color
8th Press OK
9th Press OK


Report •
Related Solutions

Ask Question