118 reputation
16
bio website meyerweb.com
location
age
visits member for 1 year, 10 months
seen Sep 13 '12 at 16:28

CSS guy.


May
8
awarded  Notable Question
Apr
9
awarded  Popular Question
Sep
13
answered Excel: conditionally format a cell using the format of another, content-matching cell
Sep
13
awarded  Commentator
Sep
13
awarded  Scholar
Sep
13
awarded  Supporter
Sep
13
accepted Excel: conditionally format a cell using the format of another, content-matching cell
Sep
13
comment Excel: conditionally format a cell using the format of another, content-matching cell
Turns out it IS workable—I just did what I described. I’ll post my solution, but I’m upvoting and checkmarking yours, Sean. Thank you so much for all the help!
Sep
13
comment Excel: conditionally format a cell using the format of another, content-matching cell
Thinking about it further, it seems like one way to do what I most recently asked would be check for changes within both the Key and Data areas, and if there are any then individually Dim the Key range and the Data range, and then nested-loop through both. That makes sure the formatting is always copied from Key to Data instead of from whatever cell was changed in Data. Does that sound workable?
Sep
13
comment Excel: conditionally format a cell using the format of another, content-matching cell
Now it’s becoming clear! This is really great, Sean; thank you. Is there a way to make it so that changes in the Data area also trigger the loop? I extended the A:A range to A:G but that meant that changes within Data copied the formatting of the changed cell throughout the range. Interesting, but not my intent!
Sep
12
awarded  Editor
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
I updated the original question to (I hope) make what I’m trying to do more clear.
Sep
12
revised Excel: conditionally format a cell using the format of another, content-matching cell
added 1028 characters in body
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
Ahhh…things are beginning to clear up a bit. I think we got a little crossed up in terms of what’s actually wanted, but I think I have enough now to take a stab at doing this right. Will report back when I get further along. Thanks!
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
Conditions like what? I thought this was being done so as not to need conditional formatting.
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
Okay, putting it there (instead of in Sheet1; thanks!) got me back to the error: “Run-time error 9: Subscript out of range”. When I hit “Debug” it highlights the line Sheets(1).Range("D1:D9").FormatConditions(1).Font.Color = Target.Font.Color.
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
Followup: my first sheet is in fact called “Sheet1” (I didn’t change it). I copy-and-pasted the given VBA directly into Sheet1’s code window under (General). There is a newline after End Sub. I’m using OS X Excel 2011.
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
Unfortunately I can’t get it to work: at first any changes to $A$1 got me a “error 9 subscript out of range”, and now I can’t trigger any errors or changes. If I remove the “Private” the macro still doesn’t show up in the Macros list, so I can’t run it manually to see if I still get an error or not. I am pretty green at VBA and macros, so it’s easily possible I’m doing something dumb, but simple macros seem to run fine. Kinda stumped—sorry!
Sep
12
comment Excel: conditionally format a cell using the format of another, content-matching cell
That looks most promising, Sean—thanks! I’ll try it out as soon as I can and report back with the results (and, hopefully, an upvote/check).
Sep
11
awarded  Student