Need to override Conditional Formatting by manually filling a cell

**auslegung** · 02-11-2013, 04:47 PM

The title says it all. How can I manually fill a cell that is already filled by conditional formatting? Thanks!

**Jakobshavn** · 02-11-2013, 05:07 PM

First Clear the cell and then enter values and formatting manually. From the Home Tab:

Clear > Clear All

**FDibbins** · 02-11-2013, 05:08 PM

put in another CF rule that will keep the cell blank

**auslegung** · 02-12-2013, 12:55 PM

It needs to be automated because the people using the spreadsheet are not going to easily change the way they use the sheet. Luckily, I'm able to edit the CF to only highlight the cells that are never going to be edited, so the users can manually highlight the other cells when they are edited. But thanks everyone!