Question

what is meant by conditional formatting

Answer 1

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have thatformatting 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.

Answer 2

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.

It is used to highlight values in a set of data.