Excel Video 45 starts at the top of the Conditional Formatting menu with the Highlight Cells Rules. Highlight Cells Rules do exactly that, they highlight or conditionally format cells that meet certain criteria. Excel Video 45 shows several examples, both with numbers and text. We’ll start by looking at collections for a group of physicians over 5 years. Highlight Cells Rules make it easy to find years when physicians’ collections were high and low, based on criteria we specify. After demonstrating how greater than works with collections over $750,000, I’ll show you how to customize the formatting in the less than $550,000 example. There are a wide variety of ways you can customize the cells’ formatting to make your data really stand out.
After the numeric examples, I also include a couple of text based examples for a list of doctors and a list of CPT codes. If you’ve never used wildcards before, an asterisk (*) allows for any number of characters (Dr. S* finds all physicians whose names start with S) and a question mark (?) allows for just one character (???6? finds all codes with 6 as the fourth digit). I also go through how to edit an existing rule. Don’t worry if that part of the example went quickly. We’ll have lots more rule editing in future videos.
Highlight Cells Rules are some of the most basic Conditional Formatting techniques. Stay tuned. Next time, we’ll see how Highlight Cells Rules apply to dates and help you find duplicate and/or unique values in a list. Thanks for watching.