IF statement problem

S

simon

I have a simple IF statement...

=if(A1=B1,"same","Different")

what i'd really like, is if B1 is not the same as A1 display "different" and
also change the cell colour to red.
is this possible??

SS
 
Top