Hi,
I am trying to total cells based on the colour they changed using conditional formatting. I have tried various ways but it doesnt work.
I want this figure to fire in automatically, not when prompted and not by filtering manually to get the number.
Thanks!
Andrew
Color isn't data. Conditional formatting is meant for the human eye.
But CF rules are logical, so you can use the same logic hidden away in your CF formulas to construct normal count functions.
The simplest solution is to move the CF formulas out into new columns where they operate as simple TRUE/FALSE results. You can even hide these new columns. Now do a COUNT on these columns counting the TRUE values.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks, I will do that...
I was starting to come to the conclusion that CF wouldn't be the way to do it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks