I need to know if I could "If Colum A not= Colum B" Change Colour in Colum A"

desmond_Erskine

Colum A (10) Colum B(5) then Colum A should be in a colour designated.

Colleen Patterson

@desmond_Erskine

The formula that @Andrée Starå also included a ,1) at the end, so format that column as a checkbox where you are writing the formula, in your example Help C

=IF([Column A]@row <> [Column B]@row, 1)

You would then be able to configure a conditional formatting rule where if that column is checked to highlight the row.

Andrée Starå

Hi @desmond_Erskine

I hope you're well and safe!

Try something like this in a so-called helper column that we'd use to trigger a Conditional Formatting rule. (change the column names to match yours)

=IF([Column A]@row <> [Column B]@row, 1)

Did that work/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!

desmond_Erskine

Screenshot 2023-03-09 111248 2.png

Screenshot 2023-03-09 111248 1.png

I appreciate your support, but please pardon my ignorance, I am unable to get it going. I am not sure if I am doing it correct.

Colleen Patterson

@desmond_Erskine

The formula that @Andrée Starå also included a ,1) at the end, so format that column as a checkbox where you are writing the formula, in your example Help C

=IF([Column A]@row <> [Column B]@row, 1)

You would then be able to configure a conditional formatting rule where if that column is checked to highlight the row.

desmond_Erskine

Thank you So much @Colleen Patterson it works perfectly.

Thank you @Andrée Starå for all the support, I am sorry I did not get it, apologies for my ignorance.

Colleen Patterson

@desmond_Erskine happy to be of assistance. If you would mark the answers as accepted, that would help other learners find this information in the future.

Andrée Starå

@desmond_Erskine

No worries! Easy to miss!

Glad we got it working!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!