Question

What is conditional Formatting?

Answer 1

Conditional Formatting is used to quickly highlight the important information in a spreadsheet. with conditional formatting, we can change the appearance i.e. Font colour, border, shading etc. of a cell based on its value or another cell's value.

Answer 2

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.