In A1 enter =AND(B1=E1;C1=F1;D1=G1)

This will return a value TRUE if B1 equals E1, C1 equals F1 and D1 equals
G1. and FALSE idf any of these three comparisons fail. You can base your
conditional formatting based on the True or False value.

( depending on your regional settings you may need to replace the ; in the
formula with a comma , )


Does this help ?

"sandernoteborn" wrote:


I think I have to use an IF but I don't know how!

Maybe I just can use an IF formula in cell A1 and compare them
seperated from eachother!

B1 - E1
C1 - F1
D1 - G1

But how do I create that formula?

Thanks


--
sandernoteborn
------------------------------------------------------------------------
sandernoteborn's Profile: http://www.excelforum.com/member.php...o&userid=34225
View this thread: http://www.excelforum.com/showthread...hreadid=539815