Skip to main content
added 69 characters in body
Source Link
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 itsthat 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

If the cells should turn green if their value is <= minimum of the range PLUS a value between 0 and 1.99% of its 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))

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

added 4 characters in body
Source Link
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 its value, the formula is:

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

if they have to turn red, the formula is:

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

If the cells should turn green if their value is <= minimum of the range PLUS a value between 0 and 1.99% of its 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))

If the cells should turn green if their value is <= minimum of the range PLUS a value between 0 and 1.99% of its 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))
Source Link
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 its 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))