conditional format a %-rank???

[RTE]

I'm trying to conditionally format a cell to be red if it exceeds the 80th %-tile of a string of numbers. Having trouble getting the formula right in the conditional formatting dialog box.

Any help would be great. Thanks.

 

[Gerald Higgins]

I used a string of numbers in the range A1:A17.

Using Excel 2003

Format
Conditional Formating
Cell Value Is
Greater than or equal to

=SMALL(A$1:A$17,ROUNDUP(COUNT(A$1:A$17)*0.8,0))

and format as required.

I have not fully tested it, but it looked like it worked after a quick test.
Test it yourself fully.

 

[RTE]

works well; thanks.