Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format Fragmentation
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel and Citrix fragmentation question | Excel Worksheet Functions | |||
copy conditional format without using format painter | Excel Worksheet Functions | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |