# 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

#1 February 21, 2014 at 21:09:36
 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*D20In 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.1When 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)

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.

Report •
Related Solutions 