Conditional Formatting or Formula
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
Thanks
Comments

Try this one out. Make sure your column titles are accurate.
=IF([% Complete (planned)]1 > [% Complete (actual)]1, "Red", IF([% Complete (planned)]1 = [% Complete (actual)]1, "Black", IF([% Complete (planned)]1 < [% Complete (actual)]1, "Green")))
I designed it for row 1. Update the titles and row numbers as needed.

Excellent, Thanks!

You're welcome. Hope you got it working!
Help Article Resources
Categories
Check out the Formula Handbook template!