Help with conditional formatting

Nicole Shapiro

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

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!