I'm struggling with finding / writing a formula in Conditional Formatting that will Cell fill and Font color change when cell matches another cell. What I'm trying to do is when cell A has the same unique "value" as Cell B then I want the condition to kick in to make the cell Red with White font.
A1 = 656238043229
B1 = 656238043229
BUT
A2 = 4260167257235
B2 = 717669750084
So I want the condition to change both A1 and B1 to a Red Cell Fill and White Font; but when it review's A2 & B2 it ignores and changes nothing.
I know how to get it to change when a "Specific" word is in question or in the quotes; but I do not have repeating values so it needs to be "wild".
Bookmarks