Conditional Formatting Question

[niebsmich]

I want to have a conditional format that a cell will turn a certain color if it does not match up to values in either one of two cells. I can do this for one cell "=c2<>b2" then turn red, for example. But how can I get it so if c2<>b2 AND c2<>f2, turn red?

 

[Ragdyer]

Little confusing !

You start out by saying "in either one of two cells", and then you end by
saying "if c2<>b2 AND c2<>f2".

Try these and use whichever one gives you what you need:

=OR(C2<>B2,C2<>F2)
=AND(C2<>B2,C2<>F2)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I want to have a conditional format that a cell will turn a certain color

if it does not match up to values in either one of two cells. I can do this
for one cell "=c2<>b2" then turn red, for example. But how can I get it so
if c2<>b2 AND c2<>f2, turn red?