Jump LinksRepeat the previous formatting step with F4Duplicate or replace formatting on a bigger scaleUse cell styles for theme consistencyCenter across selection (instead of merging and centering)Use ...

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 ...