Conditional formatting

[little dove]

I have a spreadsheet with 100 columns and 50 rows.
I want to highlight the cells with the 8 smallest numbers in each column.

I have tried conditional formatting but it will sometimes highlights a lot more than 8 cells in each column when one of the 8 lowest is repeated.

If there is a duplicate I would like it to highlight the one in the first row it comes to (from row one working down) and then ignore duplicates.

Any help much appreciated, thanks

 

[Eric W]

Glad we could help! Thanks for the feedback.