Hi All
I have data in 57 columns. Is there any way I can insert a blank column after each filled column. I am tired of doing this manually.
Thanks
Hi All
I have data in 57 columns. Is there any way I can insert a blank column after each filled column. I am tired of doing this manually.
Thanks
Are you talking about formatting or data?
If you want every second column filled with colour, select the area that you want formatted then in Condition Formatting, New, Use Formula.... Enter this and choose the formatting that you want
This will start the colour in the first column:
Formula:Please Login or Register to view this content.
This will start the colour in the second column:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks