Conditional Format??

[Guest]

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

 

[Bob Phillips]

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)

 

[Gord Dibben]

Select B2

Format>CF>Condition1>Formula is =A2="pass" format to green

Add>Condition2>Formula 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