Conditional Formatting

Giganews Newsgroups
Subject: Conditional Formatting
Posted by:  Dee (frogett…@sympatico.ca)
Date: Thu, 16 Oct 2003

I have a spreadsheet that I have rows of data that I want
to color code. For example, if certain information in
some of the cells in a row meet a certain criteria I want
the rows to be blue, other rows I want to be yellow. My
question is, if I want to get a total count of the rows
that are blue and as I add blue rows continue to give me
a running total what formula would I have to enter. Would
I use a COUNT function and if so how would I specify that
I want a count of only the blue rows.

I am using excel 2000.

Thanks in advance for any help.

Best regards,

Dee

Replies