Conditional formatting

[allana13]

Hello All,

I am trying to conditional format sale % i.e say top sales is green and bottom sales is say a different colour.

However what I am trying to achieve is only the top 3 or 4 products to be coloured green and those percentages change on a weekly basis due to different sales quantities.

I am attaching a spreadsheet where i have manually coloured what i am trying to achieve.

Please let me know if any further information will be needed from my side for you to help out.

Many thanks for your help again folks.