## (Solved) - Conditional formatting "Counting"

(7 posts)
• Started 4 years ago by amrinderminhas
• Topic Viewed 786 times

amrinderminhas
Posts: 59

hi all,
Can anybody tell me how in excel the number of cells on which i have applied conditional formatting be automatically counted and displayed.
FOR EXAMPLE:
in A1,B1,C1......z1 (26 cells) i have input the number values such as 15, 25,32,56,73,12,7,86...... respectively. Now i have applied conditional formatting of "less than 40". U all know it will colorize the cells having values less than 40 ---say its 15 cells-----. Now i want that instead of me counting the 15 colorized cells one by one, there should be a system which would display to me that there are 15 cells having values less than 40.

I hope i have made my problem clear......
thanx...

Posted 4 years ago

amrinderminhas
Posts: 59

Posted 4 years ago

GuiltySpark
Posts: 4024

amrinder...,

Hi you will have to wait for the Office experts to come online, moreeg maybe on soon.

Posted 4 years ago

moreeg
Posts: 842

Hi Amrinder

You would use the COUNTIF function again as in:

=COUNTIF(A1:Z1,"<40")

The quotes around <40 are required.

Moree

Posted 4 years ago

amrinderminhas
Posts: 59

thanx moreeg,
it worked, BUT what will be the formula to count between 40 and 50 or between 70 and 80 and so on...

Posted 4 years ago

Enthusiast
Posts: 566

For 40-50:

```=COUNTIF(A1:Z1,"<51") - COUNTIF(A1:Z1,"<40") ```

For 70-80:

```=COUNTIF(A1:Z1,"<81") - COUNTIF(A1:Z1,"<70") ```

etc...

Accepted Answer · Posted 4 years ago

amrinderminhas
Posts: 59

Yes it worked very well....
Thanx a lot for once again helping out Enthusiast and moreeg......
I m coming out with some big problem in coming days...... so watch it....lol.....
Thanx again

Posted 4 years ago

## Topic Closed

This topic has been closed to new replies.