By Richard Rost 3 years ago
Conditional Formatting Highlight Items Over Budget
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Please feel free to post your questions or comments below. Thanks.
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
Subscribe to Conditional Formatting
Get notifications when this page is updated