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 ...
I try that, change the range to Sheet1!$E$4:$E$70 and give an oke.
But when i open the rules again it is again Sheet1!$E$4:$E$7
In your former file ConditionalFormatting2 i did manage to change that range in that field.
So maybe make a hidden collum for that helper
I have tried several times to recreate the problem you have on the sample file and failed. Whenever I change the "applies to" range and close the dialog the new range is applied to the rule. There can be something different going on.
you can try to delete the multiple occurances of same rule. Other than that I have no idea why this error occurs.
I attached two files. Sheet2 with a range i cán change and sheet1 with a range i can't change
