how to remove conditional formatting

[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

 

[Bouce]

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.

 

[PCLIVE]

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

 

[David Biddulph]

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

 

[Laura]

Thanks, that worked.

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