- Press the F5 key to display the Go To dialog box.
- Click on Special. Excel displays the Go To Special dialog box.
- Click on the Conditional Formats radio button.
- Click OK.
You’re done. Excel will highlight all the cells in the current worksheet that have conditional formatting applied to them.