Solved Excel Color Coding of Score Values

February 21, 2014 at 20:30:16
Specs: Windows Vista
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

See More: Excel Color Coding of Score Values

Report •


#1
February 21, 2014 at 21:09:36
✔ Best Answer
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.


Report •

#2
February 21, 2014 at 21:18:23
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!!!

Report •

#3
February 22, 2014 at 08:12:06
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.


Report •

Related Solutions


Ask Question