Question

List any six questions which are often asked when a user wants to be benefited by conditional formatting. Also state how colour scale is used to format cells.

Hint:

Use colour scales to quickly identify trends, outliers, or performance benchmarks without using filters or formulas.

Answer 1

Six common questions when applying Conditional Formatting:

1. Which values are above or below average?
2. Which cells contain duplicate or unique values?
3. Are there any values that exceed a threshold?
4. How to highlight top 10 or bottom 10 values in a range?
5. Which rows meet a specific condition (e.g., > Rs. 50,000)?
6. How to spot trends using color changes (e.g., sales increasing or decreasing)?

Use of Colour Scale:
Colour Scales apply a gradient of colors to cells based on their value in relation to other cells in the range.
- Highest values are assigned one color (e.g., green),
- Lowest values another color (e.g., red),
- Middle values get a blend (e.g., yellow).

This provides a visual heatmap-like representation to help users instantly interpret large sets of numerical data.