Two Columns

Naish

If Column B is Greater than Column A, turn the cell "Green"

Kerry St. Thomas

That's the first step of writing a formula - thinking through the logic. So it's a simple translation to Smartsheet's formula:

=IF([Column B]@row > [Column A]@row, "Green","Red")

The @row is how Smartsheet knows to look at the same row as the formula is in. I also am thinking you could use a column with Symbols type - so this formula would show a green or red symbol.

If you want the entire cell in Column B to be green, you can then set up Conditional Formatting based on this Symbols column. You cannot set up Conditional Formatting in Smartsheet based on a formula.

More info on IF:
https://help.smartsheet.com/function/if

More info on Conditional Formatting:
https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Good luck!