Conditional Formatting


I want to use conditional formatting for a budgeting sheet I'm using with 3 columns.

Column 1 = Actual value, this figure is the cost for the item I'm purchasing

Column 2 = Budget value, this figure is the funds allocated for the item I'm purchasing

Column 3 = Delta value, this is a formula that subtracts the actual value figure from the budget value figure.

I want conditional formatting to highlight the row if the delta value is a minus figure, IE - the actual cost is above the budgeted cost.

Is it possible to do this with conditional formatting?

If yes can you explain how?

Any assistance would be appreciated!


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Go into the Conditional Formatting tool and then select your column you want to evaluate. Then you can click on the link (if needed) next to "2." to switch between selecting a value that is already entered or defining a custom criteria. You want to define custom criteria. From there you can use the dropdown to select "less than" and then enter the number zero.

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Chris440

    I see you marked @Paul Newcome's response as not answering the question. Can you clarify what you still need help with? It would be helpful to see a screen capture of your sheet and your Conditional Formatting window (like Paul's above), but please block out any sensitive data.

    Here's an article that may be helpful as well: Conditional Formatting



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!