I want cell A2 to highlight "Green" if its value increases more than 58% of the value of cell A1.
and
I want cell A2 to highlight "Red" if its value decreases more than 58% of the value of cell A1.
How can I do the above simultaneously on Excel 2010 conditional formatting? Your help will...