Page 1 of 1

[56K WARN] Excel Formatting Question

Posted: Fri Oct 20, 2006 10:36 am
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

Posted: Fri Oct 20, 2006 10:42 am
by RobertGonzalez
VBA bro, that is the only way.

Posted: Fri Oct 20, 2006 10:47 am
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

Posted: Fri Oct 20, 2006 10:52 am
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.

Posted: Fri Oct 20, 2006 10:57 am
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