Good day,

I have a table that contains +/- 12,000 (A6:R12266) rows and I use several conditional formatting rules to highlight rows where the data changes from the row above in a sorted column for the visual easy of users. The conditional formatting works great however the data is the spreadsheet is constantly being modified and that is where I run into the problem. Whenever a row is inserted or deleted my rule is divided into multiple rules which is tedius to manage and also causes the formatting to appear incorrectly in some cases. I have the table defined as a named table in the name manager and I use that name for the range in the "Applies to" in conditional formatting, but as soon as I choose apply the name is converted to the current range which becomes several seprate rules and ranges as soon as the table is modified.

I dont know if the problem is in my formula or elsewhere but any help would be greatly appreaciated.

Formula to define which rows are highlighted
=$F5<>$F6

Range data applis to after chosing the tables name and clicking apply
=$A$6:$R$12266

Thanks
Jamie