Conditional formatting, formula for the top 5 negative numbers for a row.

[hotrod]

Row A1 - FX1 of negative/positive numbers -600 to 1100.
I want to know which ones are the highest negative number (top 5) in the row.
Thanks for your help in advanced.

 

[njimack]

=AND(A1<0,a1>large($a1:$fx1,6))

 

[hotrod]

Hi Neil

The formula you have suggested does not work. Do you have any other suggestions?

 

[njimack]

In what way didn't it work? Which values did it highlight?

 

[hotrod]

Formula did not highlight any numbers.

=A1<=LARGE($A1:$FX1,6) Highlights all the negative numbers, but I only want the top 5.