XL 2007
Apply required filter
Select the range of visible cells.
Click Find & Select (In Editing block far right of Home Ribbon)
Select Go To Special
Select Visible cells only
Apply required format.


XL 2002 and 2003
Apply required filter
Select the range of visible cells.
Select menu item Edit
Select Go To
Click Special button
Select Visible cells only
Apply required format.

--
Regards,

OssieMac