Count

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,

I have a total column and use format condition.

Ex: If a number is =>90,it will change to red color
If a number is <90, it will change to green color.


At the end of sheet, I would like to have a total of red
and green.

Ex; 25 red and 15 green (just count, not a value of cell)

Thank you
Loi
 
Hi
use
=COUNTIF(A:A,">=90")
and
=COUNTIF("A:A"<90")

It would be VERY difficult to evaluate the conditional format colors
 
You must log in or register to reply here.

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

Changing cell colors 1
Conditional Formatting 3
Excel 2003 - Adding up cells that contain Conditional Formatting 10
How to filter rows data based on background color of individual cells 1
Count 2
COUNT IF - Conditional Formatting 2
Counting the number of rows based on the color 2
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0

Back
Top