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 is blue, but i would like it to change to black if the cel has a referal on sheet1.
Is it possible to make a formula to get this done?
And is my question even clear?
Txs
Caroline
