From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Using custom conditional formatting - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Using custom conditional formatting
In the last movie, we applied pre-made automatic conditional formatting rules. We just only had to do was click and Excel evaluated the numbers against each other automatically. In this movie, we will take a little bit more control over the conditional formatting. Let's take a look at few things. First click on this down arrow here in the name box and choose the data area and over here let's go to Conditional Formatting and let's look at some Cell Rules. And let's choose Greater Than, and let's say we want to find all numbers that are greater than 800 and we will choose Yellow Fill with Dark Text. Okay, and deselect if you want so you can see that rule. Okay, press Ctrl+Z to undo. Now let's go back to Conditional Formatting. Let's say we want to find low numbers. So we will highlight Cell Rules and this time choose Less Than and let's find numbers are less than 100, and we will choose the default formatting, click OK, and there we could see all of those numbers highlighted that are…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.