I'm using the gantt chart template made by Vertex. I'm trying to count how many cells with color by column. For some reason the VBA I found works on cells with conditional formatting outside the chart but not colored cells within the chart. I did some trial and error. If I use conditional formatting to fill cells with color when blank, it works. Attached is the template. Thank you.
Bookmarks