From the course: Excel 2010 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using conditional formatting

Using conditional formatting - Microsoft Excel Tutorial

From the course: Excel 2010 Essential Training

Start my 1-month free trial

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 those numbers…

Contents