Hi Guys
I have a set of conditional formatted data and i would now like to count these "color fonted" cells using VBA.
Apart from that, how can i also count the cells labelled "-" and "N/A" ?
Appreciate some pros advice.
Hi Guys
I have a set of conditional formatted data and i would now like to count these "color fonted" cells using VBA.
Apart from that, how can i also count the cells labelled "-" and "N/A" ?
Appreciate some pros advice.
No VBa code or excel formula can count conditional formatted cells
Your code or formula will need to replicate the formula in your conditional formatting.
Hi Mehmetcik,
Do you mind explaining how can that be done ?
Thanks
Please see the attached sheet to see if this is what you are trying to achieve? There is a helper coloumn "O" which you can hide or move this helper column as per your convenience.
Last edited by sktneer; 08-25-2014 at 08:10 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Maybe:
Places results in E1,F1,G1. BTW the one font color is not conditionally formatted. It is set manually.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks