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 ...
You know the routine: you click the little arrow on the column header, the massive dropdown menu appears, and suddenly you ...