View Single Post
  #1   Report Post  
simon
 
Posts: n/a
Default IF statement problem

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