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 •

#1
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:

=IF(A1=TODAY(),TRUE,FALSE)

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

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question