Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Conditional format - Column value compare

jb@59069
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.

 

Comments

This discussion has been closed.