format ='s another cell

[me]

Can cell A1 have conditional formats and then have cell B1=A1 and have B1 then also automatically change its formats everytime A1 changes

Thanks

 

[Frank Kabel]

Hi
you have to apply the same conditional format in cell B1 as in cell A1.
Formulas can't transfer formats

 

[Frank Kabel]

Hi
not possible with formulas. Sorry

 

[me]

How about VB

thank

 

[Frank Kabel]

Hi
also not really possible. E.g. if you change the format of your source
cell there's no event which is triggered to copy this format. the best
workaround would be to use a OnTime method (but this will slow down
your worksheet)

 

[me]

Never heard of this. Where can I go for help on this

Thanks

 

[Frank Kabel]

Hi
see: http://www.cpearson.com/excel/ontime.htm

But IMHO I wouldn't go this way. Excel is just not suited to copy
formats automatically!