Help with conditional formatting

Nicole Shapiro · 2022-07-12T19:51:32+00:00

There was an error rendering this rich post.

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

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!

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:

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.