Conditional formatting on dynamic named range
Hello
I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range ="WholeMain" it changes the range to absolute address =$A$1:$V$379;$A$399:$V$768 skipping the rows 380...398. I have tried to delete the range name and recreate it. I have also recreated all conditional formatting without any success. For any reason one of the formatting clause applies to those rows, but leaving column C unformatted.
Regards
Håkan
|