Forum Discussion

IJSKO's avatar
IJSKO
Copper Contributor
Sep 03, 2019

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 ...
excel
Formulas and Functions
IJSKO's avatar
IJSKO
Copper Contributor
Sep 03, 2019

erol sinan zorlu 

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. 

  • IJSKO's avatar
    IJSKO
    Copper Contributor
    Sep 03, 2019

    erol sinan zorlu 

    Wow, this looks like what i want!

    That's great!

    Do i need to use that extra collum? For the helper formula?

    • erol sinan zorlu's avatar
      erol sinan zorlu
      Iron Contributor
      Sep 03, 2019

      IJSKO 

      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.

      • IJSKO's avatar
        IJSKO
        Copper Contributor
        Sep 03, 2019

        erol sinan zorlu 

        Hi, great, but i cannot seem to adjust this one though. 

        I did manage to change this one

        =ALS.FOUT(VERGELIJKEN("=" &ADRES(RIJ(Sheet1!$E4);KOLOM(Sheet1!$E4);4;;"Sheet1");INDEX(FORMULETEKST(Sheet2!$E$5:$E$80);;);0);0)

         

        But not this one

        Sheet1!$E$4:$E$7 . i try to make this into E$80 as well, because now i can only make it happen to a few lines

Resources