Skip to main content
3 of 3
added 69 characters in body
Daniele
  • 2.4k
  • 2
  • 6
  • 14

If the cells should turn green if their value is <= minimum of the range PLUS a value between 0 and 1.99% of that value, the formula is:

=and(G3:N3<>"",G3:N3<=101.99/100*min ($G3:$N3))

if they have to turn red, the formula is:

=and(G3:N3<>"",G3:N3>=102/100*min ($G3:$N3))

no color if the cell is empty

colors

Daniele
  • 2.4k
  • 2
  • 6
  • 14