I've got a spreadsheet with a broad variety of formatting used throughout, and but not all the formatting is contiguous (unfortunately). Ultimately, what I need is to set a range of cells where they're shaded to ColorIndex 15 and bold text. I've got this part here:

Please Login or Register  to view this content.
What I'm having trouble with is figuring out how to set the range the use the cells with those criteria next. Can anybody help with this? I'm assuming I need some sort of a Find function, or possibly a pair of For Next loops as a scraper (maybe the Application.Union function to build the range?) I'm working in Excel 2010