Conditional Formatting When 1 column matches another

Andi Hawes

Id like to highlight a cell in particular column when it matches another column, cell is same row. I dont seem to have an option in conditional Formatting in 'Set Condition' to say 'if Column A = Column B'?

Andrée Starå

Hi Andi,

You need to use a so-called helper column for that. You could use a formula in a  checkbox column that checks if two cells are the same.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting