jtdestroyer
New Member
- Joined
- May 4, 2016
- Messages
- 3
I am using the following website to try and count the coloured cells in workbook (including the code posted):
https://www.ablebits.com/office-addins-blog/2013/12/12/count-sort-by-color-excel/
I have conditionally formatted my work, and I can see that it is working (all the cells I want coloured are, in fact, coloured) but when I click to check the format of the cells, it says that they are white, while they are actually green. I cannot count the green cells then because Excel thinks that they are white, I'm not sure if there is something simple I'm missing or what.
I'm pretty new to Excel so any advice on how to proceed would be greatly appreciated.
https://www.ablebits.com/office-addins-blog/2013/12/12/count-sort-by-color-excel/
I have conditionally formatted my work, and I can see that it is working (all the cells I want coloured are, in fact, coloured) but when I click to check the format of the cells, it says that they are white, while they are actually green. I cannot count the green cells then because Excel thinks that they are white, I'm not sure if there is something simple I'm missing or what.
I'm pretty new to Excel so any advice on how to proceed would be greatly appreciated.