Page 59 - Excel Data Analysis

04 537547 Ch03.qxd 3/4/03 11:50 AM Page 45

EVALUATE WORKSHEET DATA 3

After you apply conditional formatting to a worksheet, You can remove any of the conditional
the only way to recognize cells that contain conditional formatting by selecting the range of cells
formatting is to select the cell and then view the and clicking Format ➪ Conditional
Conditional Formatting dialog box. A quick way to locate Formatting to display the Conditional
cells containing conditional formatting is to use the Go Formatting dialog box. Click Delete, and the
To Special dialog box. You can display the Go To Special Delete Conditional Formatting dialog box
dialog box by clicking Edit ➪ Go To and then clicking displays. Click the options ( changes to )
Special in the Go To dialog box. In the Go To Special that correspond to the conditional formats
dialog box, click the Conditional formats option ( you want to remove.
changes to ). Excel provides two additional
options: All and Same. Click All to find the cells that
contain any conditional formatting. If you only want to
find cells with the same conditional formatting as the
currently selected cell, click Same. Click OK and Excel
locates the cells that contain the specified formatting.

■ Excel displays the fields to ■ If desired, click Add and ■ Excel applies the
create a second conditional repeat steps 3 to 8 to create a conditional formatting
formatting definition. third definition. definition to the selected
cells.
‚ Repeat steps 3 to 8 to — Click OK.
create the second definition.

45