Thread: [Solved] How to maintain formula while using Merge and Centre command
View Single Post
 
Old 04-11-2016, 07:02 PM
Aditya M Aditya M is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Mar 2016
Posts: 5
Aditya M is on a distinguished road
Default How to maintain formula while using Merge and Centre command
Hello,

I have applied alternate row highlight formula that is =MOD(ROW(),2) but when I use merge and centre vertically that is column wise I am unable to maintain alternate row colors that is white and the color that I have chosen.

I get consecutive white or consecutive rows of color that I have chosen.please guide.
Reply With Quote