If you already have a formula for the condition format, it sounds like part
of that formula would have to be calculating what the percentile is, and you
could use that in column B.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"BLR" wrote:

In column A I have a list of nuimbers. I ran a conditional format to
highlight certain ranges of percentiles (above 80% and above 90%). Is there
a way to get column B to acutally display what the percentile is?