Previous Topic Next Topic

Conditional Formatting Question

Closed
chopper1987 - 11 Oct 2010 à 02:44
nephilim3uk Posts 11 Registration date Monday 9 August 2010 Status Member Last seen 27 October 2010 - 11 Oct 2010 à 04:56
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

Réponse 1 / 1
nephilim3uk Posts 11 Registration date Monday 9 August 2010 Status Member Last seen 27 October 2010 1
11 Oct 2010 à 04:56
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

Similar discussions

My account locked connect to gemail
Karthik -
winko -

2 responses
Keyboard troubles
jimbobjoe -
car -

38 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response