Need to highlight if two numbers in two different columns match

tvanderhooft

I have a number of days column called "Adjusted Duration" (it is calculated from two other columns) and then I have a helper column called "Days" that is a number that is converted from the System Duration column into a number using this formula (=Duration@row). I need to compare these two numbers (Adjusted and Days) and highlight the system Duration cell if the 2 numbers don't match.

Example:

Adjusted Duration = 3, Days = 2, Then, Highlight "Duration" cell of 2d

If Adjusted Duration = 3, Days = 3, then don't highlight.

Thanks in advance!

Carson Penticuff

There isn't an option to set this up directly as conditional formatting. What you can do is add a helper checkbox column to evaluate the two columns and setup your conditional formatting to apply if that column = 1.

=IF([Adjusted Duration]@row <> [Days]@row, 1, 0)