SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

(Solved) - Conditional formatting "Counting"

(7 posts)
  • Started 2 years ago by amrinderminhas
  • Latest reply from 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 2 years ago
Top
 
amrinderminhas
Posts: 59

hello kindly someone answer this.......................

Posted 2 years ago
Top
 
GuiltySpark
Posts: 4024

amrinder...,

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

Posted 2 years ago
Top
 
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 2 years ago
Top
 
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 2 years ago
Top
 
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 2 years ago
Top
 
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 2 years ago
Top
 



Topic Closed

This topic has been closed to new replies.