What is the advantage of conditional formatting?

 

The attention (Transient) span for a human is said to be as low as 8 seconds. Some researchers do disagree with this number, but the widely accepted fact is, span is low. Even the focused attention for a healthy adult is not more than 20 min.

And, hence the birth to data visualization and that’s where condition formatting comes into the picture.

Let’s consider a very simple example, below figure shows Monthly sales data of the sales persons without condition formatting:

Now here is the data with condition formatting using ‘Data bar’ option in condition formatting. Looks better!

Condition formatting can have major effect in the way data is presented. For example, below shows employee attendance schedule (template readily available in MS EXCEL)

WITHOUT CONDITION FORMATTING:

WITH CONDITION FORMATTING:

Condition formatting can be used to highlight cells as per predefined rule. You can use various color coding or icons to highlight current status, blank cells etc; also, condition formatting can be used to highlight rows or columns depending on the data updated in.

What is the advantage of conditional formatting?

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