Hi
I am trying to merge cells with conditional formating.
I am trying to represent below but its hard. hope you guys understand what I need.
Ie:
1.I would like to merge From Jan1 to Jan 4 and write insde the merged cells "A"
2.Merge Jan 5th to Jan 9th and write inside the merged cells "B"
3.Merge Jan 10th to end and write inside the merged cells "C".
<TBODY>
</TBODY>
but instead of having A written multiple time, cells merged and A written once.
Thanks
I am trying to merge cells with conditional formating.
I am trying to represent below but its hard. hope you guys understand what I need.
Ie:
1.I would like to merge From Jan1 to Jan 4 and write insde the merged cells "A"
2.Merge Jan 5th to Jan 9th and write inside the merged cells "B"
3.Merge Jan 10th to end and write inside the merged cells "C".
| Jan-1-2014 | Jan-5-2014 | Jan-10-14 | Jan-1-2014 | Jan-2-2014 | Jan-3-2014 | Jan-4-2014 | Jan-5-2014 | Jan-6-2014 | Jan-7-2014 | Jan-8-2014 | Jan-9-2014 | Jan-10-2014 | Jan-11-2014 | Jan-12-2014 | Jan-13-2014 | Jan-14-2014 |
| A | B | C | A | A | A | A | B | B | B | B | B | C | C | C | C | C |
<TBODY>
</TBODY>
but instead of having A written multiple time, cells merged and A written once.
Thanks
