[Dba-office] Dynamic conditional format in Excel

I got it to work in Excel 2011 for Mac. The caveat being that when I
changed the formatting of the list, I had to change the conditional
format definition. It didn't pick up the changes I made in the list.

I can send an XLSX off list showing it if you want.

B

On Sun, Jan 4, 2015 at 11:28 AM, Susan Harkins <ssharkins at gmail.com> wrote:
> 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.
> _______________________________________________
> Dba-office mailing list
> Dba-office at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-office



-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"