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 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
20 Replies
IJSKO If the referenced value is unique you can use MATCH to check the value exists in the other sheet. Than use this formula in conditional formatting. Is it possible for you to share the workbook?
I cannot share the original workbook, but the example yes.
In sheet 1 i add my numbers and the moment i refer to these data in another sheet i would to have the color changed in the cel on sheet 1.
please check the attachd documents
Hi
our Team mate tauqeeracma has guided you correctly to conditional formatting rule.
I would suggest tauqeeracma to add a second rule to achieve the desired outcome (same exact concept but, when condition when is not met, condition 2 will take over
Good Luck
Nabil Mourad
Thanks nabilmourad .
I think the second rule will also not help because as per my understanding the requirement is to colour the cell if it is being called in another sheet. Whereas I put a conditional formatting rule in the cell that receives value from other sheet.
Sample data file will surely help to suggest more specific solution.
Tauqeer
Hi IJSKO
You can use below formula in conditional formatting, hope it will work as required.
=MID(FORMULATEXT(E5),2,6)="Sheet1"
Sample file is also attached for reference.
Thanks,
Tauqeer
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
