Forum Discussion
custom layout worksheet
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.
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
Which version of Excel do you use?
If you want the formula to be applied a wider range then you need to change then you need to change the target range of the rule as seen in the attached picture.
The version is 16.26 (office365 package)
And i tried to change that range to a higher number, as i did in the formula, but it didn't save
IJSKO Hello,
Wehn I change the range in "applies to" box, the formatting works for all the cells that is int he first sheet.
