Excel 2010: Conditional Formatting

Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly drawn to what you are looking for. Here in part 1 I get you started with highlight cells rules, data bars, color scales, icon sets and top-bottom rules. You will also see how to clear a rule.

In part 2 we take a look at how to manage rules and how to customise the formatting of a conditional format. You can also delete and manage rules, change icons in an icon set and see more conditions.

Conditional Formatting Part 1

Conditional Formatting Part 2

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010 and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s