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

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

Select B2

FormatCFCondition1Formula is =A2="pass" format to green

AddCondition2Formula is =A2="fail" format to red.

Nothing else is required.

If A2 is neither pass or faill B2 will remain no-fill.


Gord Dibben MS Excel MVP

On Tue, 29 Aug 2006 11:38:01 -0700, Paul B.
wrote:

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