Conditional Formatting or Formula

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good Day All:

I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula?

Here is what I would like to do:

If % Complete (Planned) is Greater than % Complete (Actual), then Red

If % Complete (Planned) is Equal to % Complete (Actual), then Black

If % Complete (Planned) is Less than % Complete (Actual), then Green







Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!