Conditional formatting in a single cell based on "IF" formula

Options
kyletds
kyletds ✭
edited 12/09/19 in Smartsheet Basics

I have a simple function I'd like to use. IF cell A2 is greater than cell A1, then format the background of the cell green. If cell A2 is less than cell A1, then format the background of the cell red. 

Can this be done? Please help and thanks. 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    Yes. You will want to use conditional formatting. See the screenshot below. You will need to set a rule for red formatting and a separate rule for green formatting. 

     

    2018-07-11_08-44-18.jpg

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video