Bryan Carbonnell
carbonnb at gmail.com
Sun Jan 4 17:25:39 CST 2015
Yea, I didn't see a way to do it either, but I only looked for a couple minutes. B On Sun, Jan 4, 2015 at 6:22 PM, Susan Harkins <ssharkins at gmail.com> wrote: > Bryan, that was also my original response. She wants a dynamic update and I > don't know of anyway to make conditional formatting work that way. I think > the best I can come up with is using conditional formatting to call a udf > -- I've read that you can do that and I think I even wrote about it once, > but I don't remember -- off the top of my head -- how I did it (and maybe I > didn't!). > > Susan H. > > On Sun, Jan 4, 2015 at 6:15 PM, Bryan Carbonnell <carbonnb at gmail.com> wrote: > >> 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!" >> _______________________________________________ >> Dba-office mailing list >> Dba-office at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-office >> > _______________________________________________ > 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!"