Reordering exception ranges
Use the
and buttons to order multiple exception ranges logically.For example, you might have two exception ranges with Between as the condition. If the values within the first range (e.g. 2371 to 8846) include all the values within the second (e.g. 2676 to 3308), then only the first range has effect. But, if you exchange the order of the two ranges, then values within each range are separately highlighted.