Conditional Formatting on Two Comparable Values

StephP

Hi All,

I'm very new to Smartsheets and struggling to figure the conditional formatting/formulas out.

I have two number columns 'EBT' and 'ABT'. I need to conditionally format them so if ABT is more than EBT, it flags red. If ABT is less than EBT it flags green.

Thanks! :)

Paul Newcome

You would then need a nested IF.

=IF(EBT@row> ABT@row, "Red", IF(EBT@row = ABT@row, "Blue", "Green")

You would then create the new conditional formatting rule accordingly.

Paul Newcome

You would need to insert a helper column (can be hidden after setting up) that uses an IF formula to output an indicator.

=IF(EBT@row> ABT@row, "Red", "Green")

Then you would set up your conditional formatting rule(s) based on this helper column.

StephP

Hi Paul,

That worked a treat. Thank you!

A further question, if I may...would it be possible to add a further condition to the formula, so that it has another colour (say blue) when ABT and EBT are the same value?

Many thanks,

Steph

Paul Newcome

You would then need a nested IF.

=IF(EBT@row> ABT@row, "Red", IF(EBT@row = ABT@row, "Blue", "Green")

You would then create the new conditional formatting rule accordingly.

StephP

Thanks, Paul!

Have a great day :)