PDA

View Full Version : Excel colour banding



Susan B
01-04-2003, 05:24 PM
I have a Conditional Formatting formula from the Pearson Excel website (http://www.cpearson.com/excel/banding.htm) that displays colour banding on specified rows and I am trying to adapt it so that I can have columns rather than rows colour banded in a different workbook.

The formula I have for the rows is:

=MOD(ROW()-2,1*2)+1<=1

and that colours every second row beginning from Row 2. Can I change this so that columns are coloured instead? I want the colours to start from Column O.

If this can be done what would the formula be?

-=JM=-
01-04-2003, 05:43 PM
Replace "ROW" with "COLUMN" ;)

Susan B
01-04-2003, 06:07 PM
Yeah, well, ummm...... I tried doing that, but put in COL instead of COLUMN... :8} :8} :p

Thanks JM. :p :D