Way to find if conditional formatting triggered?
 

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

Way to find if conditional formatting triggered?
 

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

"Tsia" wrote in message
...
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