Changing cell colour through % differnce

[Closed]
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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...
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
Try this in conditional formatting box .........

=(G5-H5)/H5>0.45