Thanks for your help. I'll look into the sites you suggest.
--
sdm


"sdm" wrote:

Excel 2003 in XP:
I want to copy the formatting of one of 12 cells whose location I have
calculated. I could use the usual Conditional Formatting, but that only
gives 3 options. I need 12.

to wit: I want to copy the formatting of a cell in a row above the cell to
be formatted. In a cell to the left I have calculated how many columns of
offset to the desired format to be copied. The cell format I want to use is
in a row above my cell, and offset by 0 to 11 cells.

Any ideas? - Thanks!


--
sdm