Question

Which of the following feature will help you to highlight the literate state in purple colour and illiterate state in blue colour?
a. Conditional Formatting
b. Custom filtering
c. Cell Formatting
d. Sorting ​

Answer 1

Answer:

Conditional formatting is a feature of Excel which allows you to apply a format to a cell or a range of cells based on certain criteria. For example the following rules are used to highlight cells in the conditional_format.