Use Conditional Formatting. Check out these sites for
examples:

http://www.contextures.com/xlCondFormat01.html
http://www.xldynamic.com/source/xld.CF.html

HTH
Jason
Atlanta, GA

-----Original Message-----
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


.