Conditional Formatting

[Hardworker]

Hi,

Is it possible to "fill" only the top three cells which which is obtained by
a formula.

eg You have A1, B1, C1. If you reach the targets within each cell then D1
will be red. This is obiously applied for numerous agents.

My question again is can i "fill" only the top three agents even if more
than three reached target?

I currently using a formula to Fill the column red if the criteria is met.

Please help!

Me

 

[Sheeloo]

Try this as 'FORMULA IS'
=RANK(A1,$A$1:$A$20)<4

assuming your values are in A1:A20