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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONDITIONAL FORMATTING IN EXCEL 2010 1
Function for summing or counting cells based on a specified fill color 3
Show value from one cell in another cell if today falls between a date range 5
cell vlue based on cell back colour 7
Excel - Wich Function should I use? 1
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
SUMIF with criteria "<>" & "=" 4
IF Statement - compare to coloured cell 7

Top