I have an odd'ish request. I will receive Excel files that will contain anywhere from 10-40 labels (there is data, but for this, it's immaterial). I need to count the number of labels, determine the top and bottom range, and shade the top (at a glance, they user can see who is in the top half of that particular list). The split is not based on anything data-related (which I've fiddled with conditional formatting based on data, so I get that), just simply "who is in the top half" of that specific list. The extra odd thing is I need if it's an uneven split, to remove the extra row from the top half and leave it in the unhighlighted bottom half.

Any help would be much appreciated, because I don't even know how to go about doing this since it's not data related. Thanks!!