K B
asked on
Excel conditional format - Shift Cells Down
I have attached a picture for what I am trying to accomplish.
Effectively, I would like to insert and shift down the cells filled with the color black(pictured).
First, columns D & E, then Next columns A, B & C... then repeat
columns D & E then columns A, B & C
columns D & E then columns A, B & C
columns D & E then columns A, B & C
Effectively, I would like to insert and shift down the cells filled with the color black(pictured).
First, columns D & E, then Next columns A, B & C... then repeat
columns D & E then columns A, B & C
columns D & E then columns A, B & C
columns D & E then columns A, B & C
ASKER
Saurabh,
Thank you. Have attached the "current state" and what I would like as a "future state" in two different tabs in the attached file.
Many thanks!
K.B.sample4EE.xlsx
Thank you. Have attached the "current state" and what I would like as a "future state" in two different tabs in the attached file.
Many thanks!
K.B.sample4EE.xlsx
Quick question would the headers row will always be in black color??
ASKER
Sure that would be no problem. Yes that is how it is now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You are amazing!!!
ASKER
Yet again, you rock!
Glad to help.. :-)
Saurabh...
Saurabh...
Also in the same file just show how does the current output is and how do you want to show..?
Saurabh...