Use Conditional Formatting to Highlight Items Over Budget in Microsoft Excel

In this video, I will teach you how to use Conditional Formatting to highlight cells that are over their allotted budget in Microsoft Excel.

Lawson from River Oaks, Texas (a Gold Member) asks: I'm putting together my year-end budget report. I have the budgeted amount for an expense in column B and the actual amount in column C. How can I make it so that any items over budget show up highlighted?

Members will learn how to see multiple levels of conditional formatting, for example, we'll display items that are within 20% of their budget as yellow, equal to their budget as green, and over budget as red. We'll also see how to make a conditional formatting search box.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft excel, ms excel, #excel, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, Use conditional formatting to highlight information, Highlight patterns and trends with conditional formatting, Applying Conditional Formatting, budget vs actual

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[coreycheng]

thank you! i wish i knew about this years ago. thank you

[ZahidKhan-mboc]

Happy New Year, I pray for your good health and prosperity for 2022 and beyond. God bless you.

[cruzinsweetsntreats]

As long as the base column (letter) is going to stay the same, I'd keep it absolute, yet remove the $ in the row (number), to make it relative.

$B2 vs B2 or $B$2 (full absolute)

This just makes it more secure if I decide to add a column in between.

[ryanmeyers]

The format painter is not creating rules based on relative cell references. If I do exactly the same as you have demonstrated, it simply applies the rule to all cells I paint to the original cell. I have no idea what I could be doing wrong