Hey, all right welcome back to the Mr. Excel Podcast. I’m Bill Jelen. Yesterday we talked about Liza. Liza called us who wanted to format every other row in her data said, “Here’s assuming they are in front of you which way will be the easiest way to describe Liza.
You know send sends her email she’s so I already figure it out. Nice and really what you do? And Liza came up with the method that I had even thought them. This is pretty cool. It’s actually starts out to be a little destructive, but actually solves the problem. The beautiful thing about Liza’s option is we’re not stocked with those list one and list two that I talked about yesterday. You can choose any color as you want so we’re not format the first row, and red and the second row and the blue this would be a very obnoxious format. I’m sure you would use something better than this. So we’re going red and blue. Liza formatted the first couple of rows and then she selected those rows. Are you ready for this or that’s the one. It’s going to see more we’ll first double click the fill here. All right, and a couple of things happens.
First thing that happens is we get the red and blue. The bad thing that happens is it’s screwed off all of our data. You can see all of the numbers just change, but what Liza does, she does pair. She comes down here this little drop down and appears in the lower right hand corner. Open is drop down and says, fill formatting only, and all of our original numbers and data come flying back and she is now applied every other row formatting. Isn’t that beautiful?
I salute Liza alright good I’m giving you an Excel master pin for that one. A great idea it’s much more flexible and that we can use any color if we want. It does kind of take right away when you lose all of your data, but you know it’s all there in the undo deck and basically here it come flying back when you choose fill formatting only. So another way to do formatting in a red row still though we have the problem that if we insert some new rows the formatting is partly screwed up.
Tomorrow we’ll talk about a better to solve that problem. More is actually dynamic and can deal with the rows being inserted.
Thanks for stopping by we’ll see you next time for another net cast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services