| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 31806 | 2003-04-01 06:24:00 | Excel colour banding | Susan B (19) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 132636 | 2003-04-01 06:24:00 | I have a Conditional Formatting formula from the Pearson Excel website (www.cpearson.com) 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? |
Susan B (19) | ||
| 132637 | 2003-04-01 06:43:00 | Replace "ROW" with "COLUMN" ;) | -=JM=- (16) | ||
| 132638 | 2003-04-01 07:07:00 | Yeah, well, ummm...... I tried doing that, but put in COL instead of COLUMN... :8} :8} :p Thanks JM. :p :D |
Susan B (19) | ||
| 1 | |||||