ericc
04-02-2009, 05:32 AM
Hello
I use Excel 2003.
In a workbook, I have 2 sheets. I link some cells in the Sheet2 with cells from Sheet1. (Paste as Link)
I'm searching a way to "Highlight" the cells in Sheet1 when a link to this cell exist in Sheet2.
Just to be sure that I don't forget to link a cell from Sheet1.
(So Sheet1 is the source and Sheet2 the destination)
If in a cell of Sheet2, I have : "=Sheet1!$B$25" , I would like that the cell "B25" in Sheet1 have a different background colour by example or whatever as long as I can distinguish it
Do you think it's possible ?
Thanks in advance for your help
ericc
I use Excel 2003.
In a workbook, I have 2 sheets. I link some cells in the Sheet2 with cells from Sheet1. (Paste as Link)
I'm searching a way to "Highlight" the cells in Sheet1 when a link to this cell exist in Sheet2.
Just to be sure that I don't forget to link a cell from Sheet1.
(So Sheet1 is the source and Sheet2 the destination)
If in a cell of Sheet2, I have : "=Sheet1!$B$25" , I would like that the cell "B25" in Sheet1 have a different background colour by example or whatever as long as I can distinguish it
Do you think it's possible ?
Thanks in advance for your help
ericc