automatically merge cells (containing formulas)

[Sarchiz]

Hi, I have searched and searched for a solution to my problem but couldn t find any... So here it goes
I have cells aranged in a kind of calendar style, now, in the first column i have names, then in the following columns(that represent the days of the year) i bring data that coresponds to that name and a date range .
For example, for the name john i bring the data( for example "car") from another sheet(that people fill in) that is between 9 and 15 november . The formula puts car in every single cell from 9 to 15 , while the other ones remain blank(although with formula in them).
What i need to do is to have the cells that have car in them merge automatically, so that i have "car" in the cells 9 to 15 written only once(merged and centered).
I couldn t find anything related to this , only basic stuff about manual merge and centre or formatting, but i think i found some VBA (of which i know nothing abot ) but it is only little similar and i don t know how to change the code to suit my needs...
Any thoughts on this ?

Thanks

 

[Nutster]

The functions built into Excel set the value in the cell, not the formatting, which is what the cell merge is. While Conditional Format will let you look for the repeated values and modify their appearance, it does not have merge as one of the format operations you could use. You would have to have a VBA Macro to accomplish the merge.