From the course: Excel 2013 Essential Training

Unlock the full course today

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

Conditional formatting

Conditional formatting - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

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…

Contents