Copying formatting from a cell whose location I have calculated.

[sdm]

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!

 

[Ron@Buy]

From your description it appears you are only copying the format of a few
cells, have you tried format painter?

 

[sdm]

Format painter doesn't work because the cell to be mimicked changes depending
on content. I can calculate the location of the cell whose formatting I want,
but can I then copy the formatting from that cell to my target cell?

A subset question - is it possible to copy the (conditionally changing)
format of any cell to a 2nd cell and have the second cell format change when
the first cell format changes?

 

[Ron@Buy]

OK, understand what your about but unfortunately it is beyond me - sounds
like you really require an event macro. For further info try looking at David
McRitchie's site:

http://www.mvps.org/dmcritchie/excel/condfmt.htm#find

Then move onto event macro:

http://www.mvps.org/dmcritchie/excel/excel.htm

 

[sdm]

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