Link to home
Start Free TrialLog in
Avatar of K B
K BFlag for United States of America

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


User generated image
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Can you give a sample file to play around with ..as it will be easy to manipulate that..

Also in the same file just show how does the current output is and how do you want to show..?

Saurabh...
Avatar of K B

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
Quick question would the headers row will always be in black color??
Avatar of K B

ASKER

Sure that would be no problem.  Yes that is how it is now.
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of K B

ASKER

You are amazing!!!
Avatar of K B

ASKER

Yet again, you rock!
Glad to help.. :-)

Saurabh...