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 Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History