Hello,
How do I get CountCcolor or GetColorCount VBA module to work with Conditional formatting? Yes, I did insert the VBA module correctly and saved as macro enabled template.
Let's say in example: if a person has no date or data on cell then it's highlighted as red (I put =A5:A10="" fill color red on conditional formatting) it works but when I try to count that color by either =CountCcolor(A5:A10,A1) or =GetColorCount(A5:A10,A1) - A1 being referral red color. I tried both vba module code which unfortunately did not work.
I have attached my sample workbook that doesn't work. Also, I have attached another workbook that works for your review and see what I missed or did wrong. Thank you and much appreciated !
PS - just side question: Can I do conditional formatting if it's before specific date like i.e. if it's all before 2018 then it would turn red and if it's within 2020.10.31 then stay green and if date is within 3 months from now then yellow? Thanks alot.
Bookmarks