.

Also question is, how do I get rid of conditional formatting?

Select the range that you want to remove the conditional formatting.

1. Click Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
2. Click Home > Conditional Formatting > Clear Rules > Clear Rules from Entire Sheet, and the entire worksheet conditional formatting will be removed.

Beside above, how do I turn off formatting in Excel? To remove cell formatting in Excel, select the cells from which you want to remove all of the formatting. Then click the “Home” tab in the Ribbon. Then click the “Clear” button in the “Editing” button group. Finally, select the “Clear Formats” command from the drop-down menu that appears.

Keeping this in view, how do I turn on conditional formatting in Excel?

To create a conditional formatting rule:

1. Select the desired cells for the conditional formatting rule.
2. From the Home tab, click the Conditional Formatting command.
3. Hover the mouse over the desired conditional formatting type, then select the desired rule from the menu that appears.
4. A dialog box will appear.

Why does my cell turn red in Excel?

If the rules (conditions) that you specified are met, then the formatting is applied. For example, you can set conditional formatting so that a cell turns red if its value is low, and turns green if its value is high.