Hi,
Is it possible to merge cells and get a value on it if they are already conditionally formatted?
I am creating a timeline Gantt-chart which is working from a specific date to end date, so it creates a bar or select those cells and color them on basis of conditional formatting m using on it. And now I want to show value on those cells for example say I am showing weekdays in a week so I will be able to merge those 5 cells and put a value saying we did 10 tasks in this week?
eg: start date - 26th sep 2010 & end date - 26th oct 2010, all cells between this time period becomes green as per conditional formatting because project was completed. Now I want to merge these colored cells & add value on top saying 20 tasks were done with in this period.
Thanks in advance
Vikram