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