Go to the Edit menu, pick Clear, and then Formats.
If you delete just the contents of a cell, then its formatting will stay. Then next time you put something into the cell, it will use that format.
There is a delete option when you open the Conditional Formatting option. You could also use the Format Painter to paste formatting from a cell with no conditional formatting onto the cell that has.
Format as you type
format as you type
What is the difference between delete and format?
To format a cell in excel right click on it, then on the thing that pops up click on format cell
If you press the Delete key, it will remove the data, but the formatting will remain, such as the colour or fonts or numeric format. When you type another similar piece of data in, it will apply the formatting to it.
You can delete text in an Excel cell by pressing Backspace or highlighting the text and pressing Delete.
Right-click the cell, and then click on 'Format Cells'.
Format it or delete it.
format the items
Format drive C