I appologize: I read your question wrong

"bj" wrote:

you might try a countif function with whatever criteria you used in the
conditional formating

"Ken" wrote:

Excel 2000 ... Approx 40 Columns x 5000 rows. Conditional
Formatting in various Columns set to high-lite cells
(pattern RED) containing suspect data requiring attention.

Above said ... I need to count the number of Rows that
contain any cells (single or multiple) containing a RED
pattern activiated by Conditional Formatting. Regardless
of how many cells may be high-lited in a single row ... I
need the row to count as "1" ... so I can get a total
count of rows with suspect data.

If this can be done ... I know it can be done here ...
Thanks ... Kha