how to remove conditional formatting

  • Thread starter Thread starter Laura
  • Start date Start date
L

Laura

I am trying to remove a conditional format. I followed the directions and
was able to remove the formatting but it only worked for that cell. When I
typed the condition in another cell the formatting would come up again. How
do I remove the conditon permanently?

I am using Office Excel 2003
 
Hi Laura

I believe you have to select all the cells from which you wish to remove the
formatting and then go the to conditioanl formatting and remove the condition
and conditions are setup per cell.
 
If you want to remove it from an entire sheet, press Ctrl + "A" to select
all cells.
Click Fomat, then Conditional Formatting. Click Delete and check all three
boxes.

HTH,
Paul
 
Select the whole sheet (by clicking on the box in the top-left corner,
beyond A1), then Format/ Conditional Formatting/ and delete the condition.
 
Thanks, that worked.

PCLIVE said:
If you want to remove it from an entire sheet, press Ctrl + "A" to select
all cells.
Click Fomat, then Conditional Formatting. Click Delete and check all three
boxes.

HTH,
Paul
Click to expand...
 
Back
Top