[56K WARN] Excel Formatting Question

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

[56K WARN] Excel Formatting Question

Post by MrPotatoes »

how would i be able to make it so that every rown going down (evens or odds) a different easy on the eyes colour?

like this:
Image

although i choose the colours and i don't have to do it manually. i have 2700 rows to go throuh all on different worksheets and that's a serious pain in the ass.

anyone know :D
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

VBA bro, that is the only way.
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

Post by MrPotatoes »

NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

*cries like a baby*

i found that there is a auto format thing but ti's terrible. i don't want to use it because it's ugly and i can't choose the colours. there has to be another way!

basically, i don't want to learn VB
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

If you want it to be automatic and alternate, then VBA will be your best bet. It is not that hard to grasp, expecially if you know PHP. Syntax is different, but process is very similar.
User avatar
MrPotatoes
Forum Regular
Posts: 617
Joined: Wed May 24, 2006 6:42 am

Post by MrPotatoes »

i know. i just really don't want to learn yet another language in order to get one thing done. the worst part is that as son as i learn i'll be trying new things in excel and i just don't have the time for that.

man, i suck lmao

thank you tho :D
Post Reply