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:

Screen Shot 2022-07-12 at 3.44.20 PM.png

I thought I could achieve that with the following conditional formatting rule:

Screen Shot 2022-07-12 at 3.49.37 PM.png

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! :)

Find more posts tagged with

Conditional Formatting

Accepted answers

All comments

Mike TV

@Nicole Shapiro

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:

Nicole Shapiro

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.