First, format G1:G20 as Red fill (all cells red)
Set conditional formatting in G1 to:
Condition 1
Formula Is: =OR($G1=2,$G1=5,$G1=6,$G1=7,$G1=9,$G1=13,$G1=20) and set
FormatPatterns to Orange
copy this formatting down to G20 using the Format Painter.
All cells will have Red fill unless it contains one of the six values
listed above.
HTH
Bruce
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=394982