Microsoft Office Tutorials and References
In Depth Information
When these cells are selected, you can then format them any way you like. Note that you can
widen the columns in the list of found cells (by dragging a column border), and you can also sort
the list by clicking a column header.
Conspicuously absent from the Find and Replace dialog box is the ability to search
for cells by their styles. Despite the fact that (beginning with Excel 2007) Microsoft
places increased emphasis on cell styles, it’s not possible to find all cells that use a
particular style and apply a different style to those cells. You can find and replace the
formatting, but the cell style does not change.