Conditional Formatting Question

Closed
chopper1987 - Oct 11, 2010 at 02:44 AM
nephilim3uk Posts 11 Registration date Monday August 9, 2010 Status Member Last seen October 27, 2010 - Oct 11, 2010 at 04:56 AM
Hello,

I am having problems with conditional formatting on Microsoft Excel 2003. The Excel file I am trying to format is basically a long list of tasks that I need to do in work and then 2 columns; 1 with date due and 1 with date to start. I want to highlight any dates that are before today's date red, any with todays date orange and any date after today's date green. I'd like any blank cells to also remain blank. Can anyone help with this please, I've tried a few formulas after reading up on a few forums but I'm still having problems.

Thanks in advance,

Craig

1 response

nephilim3uk Posts 11 Registration date Monday August 9, 2010 Status Member Last seen October 27, 2010 1
Oct 11, 2010 at 04:56 AM
Hi
You could use conditional formatting off the format menu.
Set the 3 conditions to be;
Condition 1 = Cell Value is, equal to, =TODAY() (then format orange background)
Condition 2 = Cell Value is, less than, =TODAY() (then format red background)
Condition 3 = Cell Value is, greater than, =TODAY() (then format green background)

hope that helps

Richard
1