Help with conditional formatting

Options
Nicole Shapiro
edited 07/12/22 in Smartsheet Basics

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

  • Mike TV
    Mike TV ✭✭✭✭✭✭
    Options

    @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
    Options

    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!