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.

Following are the questions which are often asked by the users to get benefit of conditional formatting: 1. Where are the exceptions in a summary of data over the past five years. 2. What is the trend in data over the past two years. 3. Who is responsible for such results during this month. 4. What is the overall distribution of data. 5. If it is a product related table then which product or company performed best lately. 6. Highest and lowest performing product. Conditional formatting helps to answer these questions by making it easy to highlight interesting cells or ranges of cells, emphasize unusual values and visualize data by using data bars, color scales and icon sets. Color scales are visual guides that help in understanding data distribution and their variation. A color scale helps the user to compare a range of cells by using a gradation of different colours. The shades of the colour represent higher or lower values.