0

I’m using Google Sheets.

First, I want conditional formatting to find the lowest value in a range. I've done this by entering "=G3=min($G3:$N3)" for the custom formula.

After that, I want conditional formatting to turn the cell green if it is < or = 1.99% of the lowest value in the range.

I also want conditional formatting to turn the cell red if it is 2% or greater than the lowest value in the range.

2
  • Welcome to Web Applications. What web application are you using? Mar 6, 2022 at 17:42
  • I believe there is an error in the question ... if the minimum of the range was 10, which cells should turn green?
    – Daniele
    Jun 8, 2022 at 14:45

1 Answer 1

1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.