Conditional Formatting

Options

Hi,

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!