How to add value to conditionally formatted cells in excel

[vvvv4114]

Hi,

I am running a time chart, which has a start date/end date & on basis of few conditions conditionally format cells b/w this time period.

eg:
start date 10th Jan/End date 10th Mar. Now it selects cells from 10th jan to 10th feb & color as green because till this time period all tasks are done. and leave rest from 10th feb to 10th mar in red as not done yet.
So far its working fine but now I want it to merge those cells which are green and put a value on top saying 220 tasks have been done & merge red to say 220 left.

Please help How to do this using VBA or what ever best possible way?

Thanks in Advance.

Vikram