Put your 3rd condition 1st, using this formula: =AND(ISBLANK(G4),E4<9)
I didn't use formulas for the 2nd and 3rd conditions.
************
Anne Troy
www.OfficeArticles.com

"HDV" wrote in message
...

I have a column with conditional formatting applied. Say I'm formatting
cell E4.

The column shows the number within a processing cycle which need
warning traffic lights when certain days are reached so far I have set
up:

Condition 1 shows orange if the cell value is between 9 and 11.

Condition 2 shows red if the cell value is greater than or equal to
12.

My problem is that I need a 3rd condition to grey out cell E4 if a date
is entered into cell G4. I've tried all sorts but the formatting will
not work.

Firstly can someone suggest a formula for condition 3.

Secondly do I actually need formulas in conditions 1 and 2 to state
apply formating as per the criteria above , but only if G4 is blank?

any guidance would be greatly appreciated.

Thanks


--
HDV
------------------------------------------------------------------------
HDV's Profile:
http://www.excelforum.com/member.php...o&userid=26299
View this thread: http://www.excelforum.com/showthread...hreadid=469842