Formula in Conditional Format doesn't seem to work
Posted by Ryan on August 07, 2001 7:08 AM
I have a data set with percentages (the data set is $Z$3:$Z$81). I'm trying to apply a conditional format that will highlight the largest 5 values. I've tried the following formula in the conditional format:
Additionally, the conditional format I'm trying to apply is to outline the box and shade the background grey. When I copy this format down to the other cells, no conditional formats are applied to any of the cells. I'm probable making a dumb error, but any assistance would be apprecatied. Thanks!!