I have a score value in cell D20. I have a different score value in cell I20. I want cell I20 to turn green if that score value is 10% or more higher than the score value in D20. For example: D20 score is 69%. If the score in I20 is 79% or higher, I need it to turn green. I know I need the conditional formatting, but I can't figure it out. Thanks

Maybe it's just me, but I can interpret 10% or more higher than the score value in D20 in 2 different ways: D20 + 0.1

or

D20 + 0.1*D20

In other words, 10% or more higher than the score value in D20 could mean "add 10%" or it could mean "increase the value by 10% of the original value". Again, maybe it's just me.

Anyway, if you literally want to "add 10%" then your Conditional Formatting formula would be:

=I20>=D20+0.1

When that formula is TRUE, the cell should turn green.

If you are checking for values that are higher by 10% of the original value, then you would use this formula:

=I20>=D20*(1+0.1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

The first formula you gave me worked exactly as I wanted. You're right it can be interpreted both ways. I need to see if my scores increased by 10% or more, so if it was a 69%, a green would start at 79%.

The second formula didn't work because my scores turned green at 78%, and that's not a 10% increase from the original score.

Thank you so much for helping me!!!

The second formula works if you interpret a 10% increase in the second manner that I mentioned. In other words, it

works, it just doesn't fit your requirements.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History