title: Counting cell fill colours in excel 2007 using VBA not conditional formatting
body: <p>What formula would I need to write if I wanted excel to report on the following: The number of red cells in the range H2:H30, and the answer to be returned in cell B36? The cells have changed colour based on a VBA macro and not through conditional formatting. Thanks</p>