Question

Explain the use of ‘Conditional Formatting’.

Answer 1

Uses of conditional formatting:

1. Conditional formatting helps to answer these questions by making it easy to highlight interesting cells or ranges of cells, emphasise unusual values, and visualise data by using data bars, colour scales, and icon sets.
2. A conditional format changes the appearance of a cell range based on a condition (or criteria). If the condition is true, the cell range is formatted based on that condition; if the condition is false, the cell range is not formatted based on that condition.
3. Format all cells by using a colour scale.
4. Colour scales are visual guides that help us to understand data distribution and their variation. A colour scale helps us to compare a range of cells by using a gradation of different colours. The shade of the colour represents higher or lower values.
   For example, in green colour are higher-value cells and in red colour are lower-value cells.

Answer 2

1. It helps visualise the data.
2. It also helps in checking for specific information.
3. It is also a great way to highlight top values or differences in our data.
4. Besides all this, "Conditional Formatting" enables the different features of the users to make the data more informatic and readable.
5. It also allows us to format the cells and their data effectively, which will meet the specified criteria, respectively.