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

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


.