Color Code rows

[honestabe123]

Try this macro

It uses most of the 32 palette colours, skips white, black & dark blues
If you have titles in row 1 then 3 numbers shown in the following macro in red will need to be increased by 1

Please Login or Register  to view this content.

Can you make it so that only two color are used? Something light like every other color light grey? Thank you for your time MUDRAKER!

[boylejob]

honestabe123,

If you are wanting to go down a column and change the row color on every other line for every row that has a value in column A, you can use this.

Please Login or Register  to view this content.

Of course you can change it to look at any column you want it to look at by modifying this

Please Login or Register  to view this content.

I'm not exactly sure what you are looking for, but maybe this will get you started.

[T-J]

Please Login or Register  to view this content.

This can be simplified by using Mod to test for an odd or even row number, as follows:

Please Login or Register  to view this content.

[boylejob]

TJ,

Thanks for that simplification. I knew I had seen something that would allow me to determine if a number was odd or even, but I certainly could not think what it was.

This is what this forum is all about.