Was wandering if someone can help me out with a formula that counts the number of cells that contain fill colour.
Any help will be appreciated.
Was wandering if someone can help me out with a formula that counts the number of cells that contain fill colour.
Any help will be appreciated.
If it is actually fill color (and not conditional formatting), then this procedure will work:
HTHPlease Login or Register to view this content.
Jason
Hi jasoncw,
am I right to say that your solution will need to be setup in VB or directly into the spreadsheet cell which is what Im after, also where do I fine the coding for each colour i.e red and yellow.
In the future, please be sure to use the [ CODE ] and [ / CODE ] tags around your code (without the spaces). Here is the slight amendment to your procedure that will include the result in cell C39:
JasonPlease Login or Register to view this content.
Hi Jason,
thanks mate works a treat.
Andy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks