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!
Help Article Resources
Check out the Formula Handbook template!