Find Formatted Text within an Excel Spreadsheet

[dashbored]

Hi, I've never tried posting like this before because usually every question I have can easily be answered by googling. My problem is that I need to quickly scan an Excel workbook (sheet by sheet is o.k.) to detect the presence of strike-through font, non-black text, comments or shaded cells. The reason is that these are indications that QA notes were not removed from documents that were posted to a client site. The only search methods I can find either look for formatted cells (in which case they miss cells with only part of the text struck out or colored) or they require you to do a cell by cell search, which takes way too long over thousands of documents. Searching for different formats in a full Word document is easy. Is there no way to do this in Excel without a cell-by-cell search?

 

[SkipVought]

Hi,

I believe that you have your answer. Especially when a spreadsheet application is used like a word processor or vise versa, you can see where the functionality of the other application is missing.

You're stuck with a cell by cell analysis. The programming will be extremely critical.

How Can I Make My Code Run Faster? faq707-4105

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[dashbored]

Ah. Thanks for the response! Now I can at least stop looking around for the answer. I thought for sure that I'd be able to do it because I can search for a fragmenet of text in the spreadsheet. But as you know, trying to do the same for formatting doesn't work. Thanks again!