How can I highlight two different values in two different cells

Nabil Hayek

Hi,

I would like to highlight (bold or colour or both) the value of a cell when it does not match the value of another. Conditional formatting is applied to the whole column; however, in my column I have other values so applying the CF to the whole column will not be what I am looking for.

Also, my cells are vertical and I prefer not adding another row for True or False cell.

Thank you in advance

Nabil

Nabil Hayek

Hi Andree

It seems the only way to do this. it does make sense. yeah, I want to replicate this in smartsheet.

Thanks

Andrée Starå

Hi @Nabil Hayek

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nabil Hayek

so I would like to have cell B4 in a different format than B2 because the values do not match. Since A4 and A2 are equal, the format should be the same. I would like to highlight the values that mismatch in a certain pair of cells only. I hope that helps, thank you

Andrée Starå

@Nabil Hayek

Happy to help!

Do you want to replicate this in Smartsheet?

If yes, you'd need to add a so-called helper column with a formula that checks if the values are the same or not.

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nabil Hayek

Hi Andree

It seems the only way to do this. it does make sense. yeah, I want to replicate this in smartsheet.

Thanks