If that is the only CF you have on the sheet hit F5SpecialConditional
FormatsOK

Hit the delete key.


Gord

On Sat, 7 Feb 2009 11:56:01 -0800, PointerMan
wrote:

Gord,

That did it. Thanks! Now is there a way to delete all of the cells that I
just highlighted?



"Gord Dibben" wrote:

Select the cells then Format

CFFormula is: =MID(A1,10,1)="0"

Or if 0 is always last digit

=RIGHT(A1)="0"


Gord Dibben MS Excel MVP

On Sat, 7 Feb 2009 11:06:02 -0800, PointerMan
wrote:

I meant to say that I want to do a conditional format on the selected cells
(highlight them some color).

"PointerMan" wrote:

How do I format cells that have a zero for the tenth digit?