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.