I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.

You can download the ASAP Utilities for free and install it ( add in ) then
select SELECTCONDITIONAL SELECT CELLS

http://www.asap-utilities.com/downlo...-utilities.php
Or go to Andrews and you can get info on codes for this too
http://www.andrewsexceltips.com/menu.htm


I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.

range("a2:z22").Font.Bold = False



--
Don Guillett
SalesAid Software

"Qazi Ahmad" wrote in message
...
I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to
delete
all Bold and formatted cells.

Sub Cleanup()
Dim rng As Range
For Each rng In Selection
If rng.Font.Bold = True Or rng.Interior.ColorIndex _
< xlNone Then
rng.ClearContents
rng.ClearFormats
End If
Next rng
End Sub


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 21:46:01 -0800, Qazi Ahmad
wrote:

I want to select all high lighted cells (with Bold font or cell formatted
with any color) in selected range. With one stroke. Becuase i want to delete
all Bold and formatted cells.