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.