Question

Explain conditional formatting with tge help of example list any two formats that can be usee for conditional formatting

Answer 1

It is a feature in Excel and other spreadsheet programs that allows us to apply specific formats ta cell or a range of cells on the basis of specified conditions or rules.

FORMATS

Number format

Font, font style, font color

Answer 2

Answer:

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.