Forum Discussion
custom layout worksheet
I'm looking for a way to get something done Say I have a cell in sheet1 and i'm giving it the value of a cell in sheet2 by putting a referral to it on sheet1. Originally the fontcolor in sheet2 ...
It's close but in your case the color changes in the the ceel whereto the referral goes, but i would like, in this cas, tot change the color in Sheet1!E4. So that the file sees that there is a referral to this cell
IJSKO In that case you can use 'Trace Dependents' to find if any referral is made within this sheet/cell
tauqeeracma But how do i make the color change when there is a referral?
Could you help me with that as well?
IJSKO you may also use attached file.