Filter and selection question

[tjcmills]

After applying a filter to a row of data I like to highlight only the
'filtered' data.

For example, after typing the days of the week for an entire year I apply a
filter on Saturdays and Sundays. I then select the filtered data and format
it so it is bold.

Unfortunately, with my current settings all the data is made bold - not just
the rows with Saturday and Sunday in them.

Does anyone know how to change the setting so that the bold will only affect
the 'filtered' rows?

Thanks,

 

[OssieMac]

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.