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

assuming your values are in A1:A20

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Hardworker" wrote:

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
--
--------