You are correct...If A1 is any other value than one, then do nothing.

However, I cannot get your suggestion to work...

"swatsp0p" wrote:


You only mention actions if A1= 1 or 2. What if it is blank or any
other value?

I'll assume A1 must be either 1 or 2. If it is 2, we don't want to do
anything anyway, so in B1, set CF to:

Formula is: A1=1 click FormatPatterns and select Light Gray for
fill. OK, OK to apply.

When A1=1, B1 should fill lt. gray. Any other value is the default
fill. Does this work for you?

Good Luck

Bruce


--
swatsp0p


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