Question

Answer the question

List any five conditions/formats/item that can be used for conditional formatting. ​

Answer 1

Answer:

Five conditions are:-

1) Highlight Cell  it allows us to highlight cells with more value or less, with the matching words.

2) TOP BOTTOM RULES It allows us to highlight the top cells having highest values

3) DATA BARS It allows us to highlight cells with bars inside one cell indicating their average value

4) COLOR SCALES It allows us to highlight cells with colors gradient with values

5) ICON SETS It allows us to add icons in front of a value input.