How to use Conditional Formatting in Microsoft Excel


show more Using 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 conditional formatting

Conditional formatting lets you format numbers and dates according to their value. People typically use it to highlight numbers that are especially high or especially low, but you can also highlight numbers that fall into a certain range and even find duplicate values. Before we do that, we want to select all of these numbers. So a couple of ways you can do it. Click the first number and press Ctrl+ Shift+End and that will select to the end. If you don't like doing that, you can click the first number, scroll down if you need to, and hold the Shift key down and Shift+Click the last number so it's selected.

Well if you need to select these numbers over and over again, you don't want to go through this. So let's give it a range name. Put your mouse pointer up here in name box and Click and let's call it data, a simple enough, then press Enter and now if you click somewhere to deselect, you could always go up here, click the Down arrow, choose data and immediately select t...

Using conditional formatting
Video duration: 4m 6s 6h 21m Beginner

Viewers:

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