Question

what is conditional formatting?

Answer 1

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.

Answer 2

Answer:

to create conditional formatting in excel.here areceome ways:-

1. select the desired cells for the conditional formatting rule.

2. from the home tab click the conditional formatting command.

3. hover themouse over the desired conditional formatting type ,then select the desired rule from the menu that appears.

4. a dialog box will appear.