Bold and formated cell wnat to delete in one stroke

[Qazi Ahmad]

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.

 

[ufo_pilot]

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

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

 

[Don Guillett]

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

 

[Gord Dibben]

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