VB and excel

[Mel]

I am looking to use VB with excel. I am stuck on a formula; if a range of cells are blue then sum the dollar value in this range where the cells are blue. Is this feasible?
Any help appreciated.