Conditional Formatting Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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!
==============================================
niebsmich said:
I want to have a conditional format that a cell will turn a certain color
Click to expand...
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?
 
Back
Top