Conditional Formatting - check 3 or more cells equal each other?

[doug firr]

Hello

I want to use excel (2007) to validate that various cells that should equal each other throughout a worksheet do in fact equal each other.

Lets say I type in the value "7" along a row so that cells C5:F5 all contain the value 7.

If I type the formula =if(c5=d5=e5=f5,c5,"false") I would want, in this instance, for my formula to return the value "7" or false. I'd also like to make a conditional formatting rule that if true the color becomes green.

This particular formula does not work, it returns false when it should return 7.

I did manage to do this by creating what must be an unnecessarily long ish formula by nesting smaller "if" formulas. Is there an easier way to do this anyone?

cheers

 

[Andrew Poulsom]

Welcome to MrExcel.

Try:

=IF(AND(C5=D5,C5=E5,C5=F5),C5,FALSE)

 

[doug firr]

Nice one Andrew thanks, that worked

 

[rudfaden]

As the if function can only validate one condition at a time, you need to nest the if statments inside each other. To change the celle color, you can get the if statement to return "True" and then use conditional formatting to change to the celle color.