Intro to Excel: How to Use Custom Conditional Formatting


show more Using custom conditional formatting provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

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 numbe...

Using custom conditional formatting
Video duration: 5m 49s 6h 21m Beginner

Viewers:

Using custom conditional formatting provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...