Merging cells on value based

[hmahmad286]

can anyone help me on following problem, i highlighted rows with conditional formatting, any row with date on sunday is highlighted, i want excel to merge cells C,D & E on sunday,plus show "Sunday" in highlighted cells as well.
Please help.

 

[hmahmad286]

How to paste a snapshot, i just copy paste a snapshot of excel sheet ,but it converted it in ......

 

[Joe4]

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.

Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.