Previous Topic Next Topic

Changing cell colour through % differnce

Closed
ginga ninja - May 20, 2009 at 05:09 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - May 21, 2009 at 02:35 AM
Hello,

Im trying to create a formula, were by if the differnce between two cells is greater than 30%, i want the beginning cell to change colour.

For example : G5 is greater than H5 by 45%, so A5 needs to be highlighted (fill cell with colour/or font colour change)


Been trying to do it for hours now, can anyone help ?? :(

2 responses

Answer 1 / 2
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
May 20, 2009 at 07:34 AM
Hi

Do conditional formatting
Select A5 select ' conditional formatting from Format menu
use the formula =g5-H5>0.45

Give the format you need

Do let me know If it helps...
Answer 2 / 2
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
May 21, 2009 at 02:35 AM
Try this in conditional formatting box .........

=(G5-H5)/H5>0.45



Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Best Colour Prediction Games
snehasharaf -
snehasharaf -

0 responses
If cell = date return yes or no.
JD -
ndwebb -

5 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses