Conditioal formatting problem
 

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

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

In Condition 1, use Cell Value Is between 01/01/1900 and 31/12/2100

Condition 2, Cell value is between 9 and 11

Condition 3, cell value is greater than or equal to 12


This works as long as there are no dates enter which are before
01/01/1900 and later than 31/12/2100.

Hope this helps.
Jase


--
jjj
------------------------------------------------------------------------
jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424
View this thread: http://www.excelforum.com/showthread...hreadid=469842

You need to change the order of your conditions. Check for the status
of G4 in cond. 1:

Formula is: =G4<"" set your fill pattern color to gray

cond. 2 (will only be used if cond. 1 is false)

Cell Value Is: 12 set fill pattern to color RED (may also want to
change font color to yellow for visibility's sake)

cond. 3 (will only be used if both cond. 1 & 2 are false)

Cell Value Is: Between: 9 and 11 set fill color to orange


HTH


--
swatsp0p


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