I have a Gantt Chart (range D8:IS378) that uses dates to fill the chart. Initially the chart fills in "blue" if the formula dates matches. The chart has two CF conditions that color the cells "red" and "blue". The two conditions looks in the columns "A" through "IS" for a "1" and then across the rows to see if there are more than two occurences and if there's a third occurences color the cell "red". I now want to count how many times a "red" cell occurs in each column to use for some other cells conditional formatting. This is the only way I can think of using since the cells that are in the range D8:IS378 don't have specific cell values.
I've found several references that talks about how to do this, one by cpearson and another found in vbaexpress-
http://www.xldynamic.com/source/xld.CFConditions.html
this is the site that I've tried using, but have run into a compile error and can't figure out why. I've tried the reference three different ways (cells D2, E2 and F2) and can't seem to get it to run properly. I'm requesting your professional assistance.
Charlie
See attach file for compile error/s: