trace dependants & formatting

Zadock · Feb 21st, 2002, 11:47 AM

Is there any built-in function to read another cell's formatting? Let's say A1's formula is "=B1" and B1 is formatted as bold; is there a simple way to make A1 bold as well? (Yes, I can think of a couple of ways to do it in VBA, I was just trying to keep it simple)

Feb 21st, 2002, 12:37 PM

I am having trouble doing this as well, except I am linking to cells in a different workbook. Would like to be able to format the parent cell and have the dependent cell be automatically updated. Looking forward to someone's clever solution - have been beating my head against this for several days now. Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 11:47 AM	#1
Zadock New Member Join Date: Feb 2002 Posts: 1	Is there any built-in function to read another cell's formatting? Let's say A1's formula is "=B1" and B1 is formatted as bold; is there a simple way to make A1 bold as well? (Yes, I can think of a couple of ways to do it in VBA, I was just trying to keep it simple)

Feb 21st, 2002, 12:37 PM	#2
Guest Posts: n/a	I am having trouble doing this as well, except I am linking to cells in a different workbook. Would like to be able to format the parent cell and have the dependent cell be automatically updated. Looking forward to someone's clever solution - have been beating my head against this for several days now. Thanks in advance.