K
kim
Hi
I have a sheet which shows daily events over a month blocked off with a
colour shaded cell, when a pointer is hovered over a cell an inserted comment
box gives text info about the event. A few days have 2 events so differnt
colour shades. So to do this I merge the cells that are single events and
this lets me have two comment boxes in the two unmerged cells.
This means a lot of pairs of adjacent cells have to be be merged as there a
re more venues for each day.
Is there a way a macro or something could be run that would check the cell
to the left and it it was unshaded merge the two cells?
Thanks
I have a sheet which shows daily events over a month blocked off with a
colour shaded cell, when a pointer is hovered over a cell an inserted comment
box gives text info about the event. A few days have 2 events so differnt
colour shades. So to do this I merge the cells that are single events and
this lets me have two comment boxes in the two unmerged cells.
This means a lot of pairs of adjacent cells have to be be merged as there a
re more venues for each day.
Is there a way a macro or something could be run that would check the cell
to the left and it it was unshaded merge the two cells?
Thanks