Formatting data conditionally


show more Formatting data conditionally provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Formatting data conditionally

Excel's Conditional Formatting tool on the Home tab is generally associated with information in a column or in a cluster of columns. It can also be used as a comparison tool. If we look at the data in column C and D, maybe what we want to show here with a strong visual component is that whenever these Shipping Dates are more than three days later than the Order Date, you want them to be flagged. You want them to jump out because ideally you like to have your orders taken care of pretty quickly. So in column D here we are about to apply a Conditional Formatting rule that's going to refer to the data in column C. So the Conditional Formatting button is on the Home tab.

And although there are a plenty of rules, and this is a great feature with lots of fun colorful aspects to it, we have to write a formula here. A new rule. Pretty easy though once you see the rule. Use a formula to determine which cells to format. Column D is the column in question. Now it might seem a little strange to t...

Formatting data conditionally
Video duration: 1m 54s 3h 43m Intermediate

Viewers:

Formatting data conditionally provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...