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...
0
Answer 2 / 2
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
May 21, 2009 at 02:35 AM
Try this in conditional formatting box .........

=(G5-H5)/H5>0.45



0

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
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
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Excel - IF function with multiple words
Nick -
user -

14 responses