Question

Explain conditional formatting with the help of a suitable example​

Answer 1

Answer:

Conditional Formatting is a tool in Microsoft Excel 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.

Answer 2

Conditional formatting:-

using this feature we can apply ir change the formet of the cell by creating some rules for when and how those cells are to be formatted.