If you have set it up to turn green for Pass, and red for Fail, it won't
show any colour for any other value.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul B." wrote in message
...
I have set my conditional format so that is a column A2 is Pass then B2
turns
green, and if A2 is Fail then B2 turns red.

I also want B2 to not change colour if A2 is NOT Pass or Fail.

Any ideas would be appreciated.

Cheers