Excel: identifying if all values in a row are not equal

Solution 1:

Alright, assuming your data is set up so column A is a label row, we have data from B1:F4.

First, add a helper column in between columns A and B. In B1 enter the following formula:

 =IF(AND(C1=D1,C1=E1,C1=F1,C1=G1),TRUE,FALSE)

Then copy this formula down to row 4. Your helper column should now have a value of either TRUE or FALSE for each row.

Now highlight from B1:G4 and select Conditional Formatting. Add a new rule, and select the option "Use a formula to determine which cells to format".

On Office '11 I have to select "Style: Classic" first, I'm not sure if this is necessary in Windows versions.

In the formula bar for your rule, enter "=$B1=FALSE" and select Ok.

This should do it!