Way to find if conditional formatting triggered?

[Tsia]

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

 

[Bob Umlas]

At the top of the column, or somewhere visible, you could do
=IF(MAX(A:A)>somenumber,MATCH(MAX(A:A),A:A,0),"")
and if you see a number, it's the row of ONE of the conditional formatting
cells.
HTH