How Do We Search for Formatting in Microsoft Excel?

Microsoft Excel is one of the most diverse tools you can get for spreadsheeting. Whilst I am slightly biased because I'm a Microsoft Office Specialist Master Instructor, never the less, Microsoft Excel is one of the most powerful tools you can use and in reality most people only use about 5% of the functionality that is actually in the application. One of the nifty tools I stumbled on many years ago when I first sat my Microsoft Office 2000 Master Instructor Exams was the ability in Microsoft Excel to utilise the Find command to actually search for text or cells with a specific format such as a cell that has a Yellow background or text with bold formatting.

That's right