| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 6320 | 2000-11-01 21:44:00 | excel | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 6931 | 2000-11-01 21:44:00 | conditional formating works only when the cell is made absolute, say $b$1. Is there any way that that cell reference can be changed from $b$1 in single cell changes up to say $b$50 by a macro, so that each page produced has a different set of cells formatted with a colour. The idea is to produce a roster with each rostered person getting a page with their name with a colour fill. Hope you may help. Bill. |
Guest (0) | ||
| 1 | |||||