Question

What us Conditional formatting explain with a example

Answer 1

Answer:

Conditional Formatting

Select the range A1:A10.

On the Home tab, in the Styles group, click Conditional Formatting.

Click Highlight Cells Rules, Greater Than.

Enter the value 80 and select a formatting style.

Click OK. Result. Excel highlights the cells that are greater than 80.

Change the value of cell A1 to 81.

Answer 2

Explanation:

conditional formatting 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.