Greetings,

I have a huge multi-sheet workbook that has different conditional
formatting for each column in it. Basically, the conditional
formatting is "if cellcontents somenumber, then make the background
red". Whereas for smaller spreadsheets I could easily scroll through
it looking for red cells, one of these has 16K+ rows. I'd like to
find an easy way to seach my spreadsheet for any occurance of the
conditional formatting to be true. Find - format doesn't seem to
work on conditional formatting for some reason. I've not delt with
Macros in Excel (yet), so I may have to ask for clarification if
anyone posts VB code.

Thanks,

Tsia