Conditional Formatting

Chris440

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!

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.

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

Cheers,

Genevieve