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'?
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.