hello
is there a way to count cells according to there interior color if they are formated in conditional format?
thanks
hello
is there a way to count cells according to there interior color if they are formated in conditional format?
thanks
moshe
The usual answer is no... However, there is a way, but it's by no means simple or easy - see here > http://www.xldynamic.com/source/xld.CFConditions.html
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
I don't think you can do that because CF does not use the same color index as regular cells. For instance, light green has a color index of 35 but I do not think CF uses that index.
Peace of mind is found in some of the strangest places.
CF does use the same index as regular cells, but it won't show that when looking at the worksheet object, only if you look/loop through all CF's.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables