Conditional Formatting or Formula

Tony Barthelemy

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

 

 

 

Mike Wilday

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. 

Tony Barthelemy

Excellent, Thanks!

Mike Wilday

You're welcome. Hope you got it working!