How to copy the 'format' of 1 cell to another using formula

[Guest]

How can i write a forumula/function that will copy the format of a particular
cell. Specifically I'm trying to make a cell a certain color if a condition
holds.

if (A1 = 1, 'copy the format of cell b10', 'otherwise copy the format of
cell c10')

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format'. See:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

 

[Myrna Larson]

You can use conditional formatting, but not to say "copy the format of another
particular cell". You have to enter the desired format (i.e. specify whatever
is used in B10) in the Conditional Formatting dialog box. BTW, you can only
specify 3 different conditions, so with the default format the total would be
4.


On Fri, 27 Aug 2004 13:27:01 -0700, "copy color" <copy