Help with conditional formatting
I would like to set up conditional formatting so if columns Original SeqProj Name and New SeqProj Name DO NOT match, New SeqProj Name turns yellow. Example done manually below:
I thought I could achieve that with the following conditional formatting rule:
As you can see, it also highlights the cell where the two columns match.
Any ideas on edits I need to make so it only highlights when the two are not equal?
Thanks! :)
Answers
-
That's because you've manually typed in [New SeqProj Name] into the box after 'is not equal to'. So it's actually trying to see if the contents of the cell has [New SeqProj Name] in it and it doesn't, so it's highlighting it.
What you need to do is set up a helper column like this:
Match formula:
=IF(Original@row <> New@row, 1)
Then you can hide that helper column and then setup conditional formatting like so:
-
Ah! Thanks. I was hoping that I could just reference that cell by putting the column name in brackets. I will add the new column like you suggest and then set up the conditional formatting. Thanks for your help!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives