How to Find Cells with Conditional Formatting In MS Excel XP
- Find and click Go To option from the Edit menu.
- Click the Special button.
- Click Conditional formats.
- Under Data validation, click All option to find all cells with conditional formatting. Click Same option to find cells with identical conditional formatting as the currently selected cell.
- Click OK button.