[Dba-office] Dynamic conditional format in Excel

A reader has an interesting challenge. I haven't spent any time on it yet
and I'm not sure it can be solved using conditional formatting -- I don't
think it can.

She has a list in A1:A3 and a validation control in D5 uses the list to
populate the list. She wants the validation list in D5 to assume the
formatting from the appropriate cell in A1:A3 -- all three cells have
different formats. So, if you choose the value in A1, D5's format would
match that in A1.

I'm sure this can be done with VBA, but she was hoping for a conditional
format -- I don't think it's possible because the rules just aren't dynamic
enough to handle it. Well, at least, not that I know of.

Susan H.