K
Kevin
I need to determine if any of the following groups of cells match each other.
For instance, H8&H9 match H11&H12, or H14&H15 match H8&H9, or H11&H12 match
H14&h15, etc...these cells contain a name and text that I don't want repeated
in the same column. If so, an error appears. I'm using dropdowns for all the
cells if that matters. The following formula is used for one cell under
conditional formatting and is the closest I can come to a solution, but this
will take forever to input...all ideas appreciated.
=AND(OR(H8&H9=H11&H12,H8&H9=H14&H15,H8&H9=H17&H18,H8&H9=H20&H21,H8&H9=H23&H24,H8&H9=H26&H27,H8&H9=H29&H30))
For instance, H8&H9 match H11&H12, or H14&H15 match H8&H9, or H11&H12 match
H14&h15, etc...these cells contain a name and text that I don't want repeated
in the same column. If so, an error appears. I'm using dropdowns for all the
cells if that matters. The following formula is used for one cell under
conditional formatting and is the closest I can come to a solution, but this
will take forever to input...all ideas appreciated.
=AND(OR(H8&H9=H11&H12,H8&H9=H14&H15,H8&H9=H17&H18,H8&H9=H20&H21,H8&H9=H23&H24,H8&H9=H26&H27,H8&H9=H29&H30))