Members Login
Username 
 
Password 
    Remember Me  
Freeze-Frame Radio -> Freeze-Frame Radio Lounge -> Oh Great Excel Users!
Post Info TOPIC: Oh Great Excel Users!
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Oh Great Excel Users!
Permalink  

Namely Fuzzy, but I figure that other people here might know this too.

I want to color my lines so I can see them better, for example, 1st line gray, 2nd line white, 3rd line gray, 4th line white, etc. Is there a way to automatically do that, or would I have to highlight all the rows I want to change to gray?

__________________
disco strangler


Smiles everyone, smiles!

Status: Offline
Posts: 8321
Date:
Permalink  

won't that make you dizzy?

__________________
You should fear anything that can bleed for seven days without dying...  (as told to Mr. DS on 3-12-10)
disco strangler


Smiles everyone, smiles!

Status: Offline
Posts: 8321
Date:
Permalink  

uhhh, you're not working are you?  didn't anyone tell you to day is free day?

__________________
You should fear anything that can bleed for seven days without dying...  (as told to Mr. DS on 3-12-10)
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Yeah, I'm w*rking, but it's a side project to chatting on the forum.

__________________
JD The Jazz Doctor


Grand Poobah

    



Status: Offline
Posts: 36897
Date:
Permalink  

molly I had a look at my excel- doing that sure isn't a ready to do option is it? I didn't find anything to help- sorry!

__________________
"And like Web, I enjoy throwing JR under the bus.  Problem is, it's usually under the special bus that I ride every day". Ghostdancer 12-18-09
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


Awe Nuts!

I just heard this talked about on one of the podcasts I listen to. Someone called in asking how to do that and it is possible, but since I don't use Excel or wasn't really needing that, I didn't pay that much attention to the details of how to do it.



__________________


Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Yeah, it's something I couldn't figure out how to do on my own, and I know a lot about Excel. I need someone even more advanced than me, and Fuzzy popped into my head.

__________________
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


I found where they were talking about it !

This guy just wanted ever other line highlighted like the old green/white paper:
"As for the green bar style of the old computer paper, first choose your records and then choose AutoFormat… from the Format menu and select either List 1 or List 2 from the available formats. (This is from the Mac version, but it should be pretty much the same on the PC.)"

Maybe Mr. Excel might talk more about it on his site.



__________________


WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


Found it

Greenbar formatting





__________________


Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Yes, that's it exactly! It works! I should've known Web would find it!

__________________
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


Be sure to tell Mz what a great guy I am.




__________________


disco strangler


Smiles everyone, smiles!

Status: Offline
Posts: 8321
Date:
Permalink  

are your sure you won't get dizzy looking at the lines that way?

__________________
You should fear anything that can bleed for seven days without dying...  (as told to Mr. DS on 3-12-10)
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

I'd rather be able to track the same line all the way over to the right without jumping lines, so no, it won't make me dizzy for what I need it for.

__________________
Tennessee Girl


Senior Member

Status: Offline
Posts: 244
Date:
Permalink  

Hey Molly,


I know how.  I'll trying writing out instructions.  If I'm not clear, respond back and I'll give you my phone #.


1)Get your pattern established.


2)Highlight your pattern using the numbered lines on the left.


3)Go to the last line you've highlighted and left click with your mouse the bottom right hand corner of the box. (There's about 4 different +'s patterns.  You want to move your curser around until it is a true + sign, nothing with arrows or like that.


4) Now with your left clicker still down page down as far as you want on your spreadsheet.  Once you release, it should prefill your colors.


5)  That was VERY DIFFICULT to put into words.  Let me know if you have trouble and I'll give you my phone #.   You can call me.


 



__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

Molly - I usually highlight as an after effect. So it is different than what you are doing. Since you have an in-depth knowledge of things in the compter world, I am suggesting that you take a look at the link below. I believe that should help you. At least I hope it does. Good luck.


http://www.cpearson.com/excel/banding.htm



__________________

Stop trying to be what you see. Be what you ought to be.
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

Well, I guess I answered a little late, now didn't I?

__________________

Stop trying to be what you see. Be what you ought to be.
Tennessee Girl


Senior Member

Status: Offline
Posts: 244
Date:
Permalink  

You know, there's more than one way to skin a cat.  Webguy's sounds much faster and easier.  I've learned something today too!!

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

And look at that, Web gave you the easy way. My bad. Just becareful if you are going to sort the data after you build it. The formatting may hold true to the line numbers and not your data.

__________________

Stop trying to be what you see. Be what you ought to be.
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

Yeah, Web gave me the easy way. I am sorting and such as I go along, but I just go do the autoformat again, and it's all better.

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

You know me, a day late and a dollar short.

__________________

Stop trying to be what you see. Be what you ought to be.
Molly


The Mediator

Status: Offline
Posts: 5356
Date:
Permalink  

That's okay, frankly, this time I didn't expect Web to know for once. I should've known better...

__________________
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

I have come to believe that Web knows it all.


And if he doesn't, he'll know where to look for it.


If had some more useful brain cells, I might be half as good as he is.



__________________

Stop trying to be what you see. Be what you ought to be.
Woo Hoo


The Chosen Woo

Status: Offline
Posts: 21048
Date:
Permalink  

confuzzed wrote:


I have come to believe that Web knows it all. And if he doesn't, he'll know where to look for it. If had some more useful brain cells, I might be half as good as he is.

I was going to say that well except for the useful brain cells part.

-- Edited by woo_hoo22 at 14:55, 2006-03-10

-- Edited by woo_hoo22 at 14:56, 2006-03-10

__________________
"Am I speaking in a language you're not getting here?"
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

Well, I can't help it you have better brain cells than me. It happens. I am okay with it.



__________________

Stop trying to be what you see. Be what you ought to be.
Woo Hoo


The Chosen Woo

Status: Offline
Posts: 21048
Date:
Permalink  

confuzzed wrote:

Well, I can't help it you have better brain cells than me. It happens. I am okay with it.
That's not what I meant LOL!

__________________
"Am I speaking in a language you're not getting here?"
confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  


I know. It just had to be said.



__________________

Stop trying to be what you see. Be what you ought to be.
WebGuy


Doesn't Do Windows



Status: Offline
Posts: 25589
Date:
Permalink  


I think you're giving Web too much credit.

I didn't know the answer, I had just heard it discussed a couple weeks ago and found it in the past show notes.



__________________


confuzzed


Permanent State of Confusion

Status: Offline
Posts: 27006
Date:
Permalink  

But Web, you knew where to find an answer. That still counts.

__________________

Stop trying to be what you see. Be what you ought to be.
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
Freeze-Frame Radio -> Freeze-Frame Radio Lounge -> Oh Great Excel Users!
Tweet this page Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse 		Powered by ActiveBoard