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

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

--
Regards
Frank Kabel
Frankfurt, Germany


me wrote:
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

Hi
not possible with formulas. Sorry

--
Regards
Frank Kabel
Frankfurt, Germany


me wrote:
There are way too many conditions for cell B1. I was going to have
cell B1 do a vlookup in a table from another cell that has an answer,
find the item and then use its formats. Help with this option.

Thanks

How about VB

thank

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)

--
Regards
Frank Kabel
Frankfurt, Germany


me wrote:
How about VB?

thanks

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

Thanks

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!


--
Regards
Frank Kabel
Frankfurt, Germany


me wrote:
Never heard of this. Where can I go for help on this?

Thanks