My Excel 2007 Worksheet has 19 colms & anywhere from 10 to 40 rows.
The data changes daily with deletions, insertion and additions to the
end.

Colm N has an action indicator & I have set Conditional Formatting to
highlight any "Delete" entries &I set the range to the entire column -
$N:$N.

Works great at first ... then a few days later I look at the "Manage
Rules" & the range associated with my formula has changed and been
fragmented ... eg. $N$29:$N$1048576,$N$1:$N$25. My guess is that it
is from the deletes ... but how else can I do this. How do I stop
the row changes from effecting the conditional formatting range?