#347 Ten Ways To Use Conditional Formatting

Conditional formatting is a great way to dynamically apply certain formatting to your spreadsheet data  when certain conditions are met.

If you are new to conditional formatting you can pick up the basics here.

If you’re already familiar with conditional formatting, or just curious, here are “10 cool ways to use Excel’s conditional formatting feature”

1: Distinguish business rule violations

2: Display simple icons

3: Highlight a row based on a single value

4: Create a dynamic record highlight

5: Compare values

6: Compare lists

7: Create alternating bands (aka zebra stripes)

8: Find duplicates

9: Find discrepancies

10: Find the smallest or largest duplicate

If you’re interested in any of those you can hop over to Tech Republic for all the details you need.

 

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s