chainging cell colours based on date

May 7, 2009 at 11:14:19
Specs: Windows XP
I have a task sheet with a column for start date, end date and status.

Is it possible to change the colour of the cell in the status column based on the date from the end date column?

ie. when today's date matches the date in the end date column, the colour in the status column switches.

any and all help is greatly appreciated.


See More: chainging cell colours based on date

Report •


#1
May 7, 2009 at 12:16:19
Your looking for Conditional Formatting

Start Date is in Cell A1
End Date is in Cell B1
Status is in Cell C1

1st – Select the cell C1

On the Menu Bar:

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

=IF($B$1=TODAY(),TRUE,FALSE)

Sub Menu Format :
6th - Patterns
7th - Choose Green
8th - Press OK
9th - Press OK

If you now enter Todays Date in cell B1
Cell C1 will change color to Green.

Modify to suit your needs.

MIKE

http://www.skeptic.com/


Report •

#2
May 8, 2009 at 04:32:05
Tks much for the answer Mike. I was working with conditional forumlas but messed up the IF statement string. Appreciate the help

Cheers

sean


Report •

#3
May 8, 2009 at 06:15:08
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 8, 2009 at 06:30:50
Tks much for the answer Mike. I was working with conditional forumlas but messed up the IF statement string. Appreciate the help

Cheers

sean


Report •


Ask Question