Conditional formatting with multiple cells

  • Thread starter Thread starter martinmike2
  • Start date Start date
M

martinmike2

Hello,

I am trying to make one cell red if it dosn't equal the value of 2
cells.

Let me explain,

r_pnec r_snec DNEC1
0000 0123 0256


if DNEC1 dosn't equal the value of r_pnec OR r_snec then DNEC color
would change to red, but if DNEC1 = either r_pnec OR r_snec (can't
equal both, only one of them) then the color would not change.
 
Try this:

=AND(C2<>"",A2<>B2,OR(C2=A2,C2=B2))
--

HTH,

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


Hello,

I am trying to make one cell red if it dosn't equal the value of 2
cells.

Let me explain,

r_pnec r_snec DNEC1
0000 0123 0256


if DNEC1 dosn't equal the value of r_pnec OR r_snec then DNEC color
would change to red, but if DNEC1 = either r_pnec OR r_snec (can't
equal both, only one of them) then the color would not change.
 
Back
Top