Conditional Formatting

  • Thread starter Thread starter Hardworker
  • Start date Start date
H

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