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 ...
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
Wow, this looks like what i want!
That's great!
Do i need to use that extra collum? For the helper formula?
Hi,
I just hastly created a formula to solve your problem. However now I have a little bit more time and updated the formula. you can check the attached file.