Excel saves your previous formatting criteria, so to avoid confusion, you need to clear them. Click the down arrow next to the Find What field, and select "Clear Find Format." Then, click "Clear ...

The Format Painter in Excel lets you copy formatting from one cell or group of cells to another cell or group of cells ...