Conditional Formatting

Archie123456

I have 2 columns that i want to conditional format off one another. There is primary column and secondary.

If the number in the primary column matches the secondary both cells go green,

If they do not match then both cells go red

I want this to be done automatically when a number is added into the secondary column

Protonsponge

Hello @Archie123456 -

Would having a check box helper column work for you with the formula if [Secondary] equals [Primary] then check, else unchecked? You could then build conditional formatting around the helper column being checked?

Helper formula:

=IF(Secondary@row = [Primary Column]@row, 1, 0)

Conditional Formatting set up:

I hope that is helpful to you in someway,

Protonsponge