From the course: Excel 2013 Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Conditional formatting - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Conditional formatting
In this worksheet called Conditional Formatting, we might want to make some of the years in column F standout a little more prominently. Conditional Formatting practically explains itself. We're saying we want certain numbers, those above a certain amount, within a certain range, to have a different look. And as we make the choice here, we've selected column F ahead of time, Conditional Formatting, highlight Cells Rules. How about those Greater Than? Greater than what? And immediately, we see some color changes in column F. We haven't even decided what we want yet. Format cells that greater than eight. Well, maybe we want to do this for those that are greater than nine in other words the 10's and above. Do we want to use light red fill and dark red text? Well, maybe so, that looks okay. We can see it already. We don't get a preview on these but we can imagine what some of these we might use. How about a red border maybe, something like that? Well, that looks okay. How about red text…
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.
Contents
-
-
-
-
-
-
(Locked)
Exploring font styles and effects4m 7s
-
(Locked)
Adjusting row heights and column widths3m 37s
-
(Locked)
Working with alignment and Wrap Text4m 2s
-
(Locked)
Designing borders3m 26s
-
Exploring numeric and special formatting5m 36s
-
(Locked)
Formatting numbers and dates4m 31s
-
(Locked)
Conditional formatting4m 21s
-
(Locked)
Creating and using tables9m 59s
-
(Locked)
Inserting shapes, arrows, and other visual features6m 28s
-
(Locked)
-
-
-
-
-
-
-
-
-
-
-
-