Conditional format - Column value compare

jb@59069

Hello,

I have a sheet that I need to compare the values of two columns and change the text color based on the result.

I need to compare "Suggested Hours" to "Actual Hours" (or reversed). If the "Actual Hours" value is greater than "Suggested Hours", turn the "Actual Hours" value red.

Cannot figure out how to get conditional formatting to do this.

 

Thank you.

 

Andrée Starå

Hi Jerrry,

I would add a column with a formula and set the conditional formatting to check there.

I hope this helps you!

Best,

Andrée

Unknown

This content has been removed.

Andrée Starå

Hi again Jerry,

Yes unfortunately there isn't a way to do this without a formula at the moment.

Please submit a Product Enhancement Request for this feature

Have a fantastic weekend!

Best,

Andrée