Copying formatting from a cell whose location I have calculated.

  • Thread starter Thread starter sdm
  • Start date Start date
S

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!
 
From your description it appears you are only copying the format of a few
cells, have you tried format painter?
 
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?
 
Back
Top