Count Rows with Conditional Format?

K

Ken

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
 
D

Dave O

One suggestion: insert a new column, and for each row enter an IF()
statement that matches the conditional formatting parameters. Set the
IF statement to result in 1, and then total the column.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand Conditional Formatting to all Rows 7
Conditional Formatting in a pivot table 2
Conditional Formating - by row, not by column (Office 2007) 1
Copy/Past Conditional Format 2
Conditional Format Fragmentation 2
Conditional Format? 5
Auto format blank rows using code 6
High Lighting cells with conditional colour formats 1

Top