Count blank cells by colour based on conditional formatting
Hello there,
I am new to the Forum. I am looking for a way to count blank cells by colour. The colour is based on conditional formatting and changes depending on date ranges.
I found the below thread with the CFColorIndex function, but it did not work for me.
I attach the file to this post.
Thanks for your help.
Use the CF conditions in formula to get the count.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Do you need count for the whole table or row by row?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
I need to count for the whole table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks