How-To Geek on MSN
Stop using format painter in Excel: Find and replace formatting instead
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 ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results