Hello everyone,
I have an excel sheet where I have formatted Cell M1:M1000 as conditional formatting with color codes based on the other values in the sheet.
I have 2 colors - Orange and Green.
Now I need to count the number of Orange and Green colored cells in M1:M1000.
Is there any way to achieve this?
Thanks in advance.
You cannot count formatting like that, but what you may be able to do, is use teh same rule that you used for the CF - for the count
What rule did you use?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello Admin,
Thank you for replying to my post. These are conditions in formatting.
It colors Orange
Please Login or Register to view this content.
It colors GreenPlease Login or Register to view this content.
OK so try this...
=countifs($M$1:$M$1000,"<"&$L4-1)
This formula is not working as expected.
Not getting the exact result.
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
File attached for reference.
The file attachment service is bit confusing.
So here is the download link
https://we.tl/kPQ0eSH0Gi
If K is greater than J then it is colored in Green
If J is greater than K then it is colored in Orange.
I want to count both the Green and Orange cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks