Formulas

Hi Sue, Thanks for the post, in answer to your question it sounds like an 'AND' function is required;

The And function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

The syntax for the And function is:

And( condition1, condition2, ... )

Condition is something that you want to test that can either be TRUE or FALSE. There can be up to 30 conditions.

These can be values or Cell References, so your formula could be
=AND(A1,B1,B3) and if the three cells all have the same value you will have the return TRUE, if any of them are different then the result will be FALSE, I hope that helps, good luck, Pete.