Chapter 20: Visualizing Data Using Conditional Formatting
501
Locating cells that contain conditional formatting
You can’t tell, just by looking at a cell, whether it contains conditional formatting. You can, how-
ever, use the Go To dialog box to select such cells.- Choose Home ➪ Editing ➪ Find & Select ➪ Go To Special.
- In the Go To Special dialog box, select the Conditional Formats option.
- To select all cells on the worksheet containing conditional formatting, select the All
option; to select only the cells that contain the same conditional formatting as the
active cell, select the Same option. - Click OK. Excel selects the cells for you.
Note
The Excel Find and Replace dialog box includes a feature that allows you to search your worksheet to locate
cells that contain specific formatting. This feature does not locate cells that contain formatting resulting from
conditional formatting. n