Hi,
I need help with figuring out how to change the cell based on percentage change between the cell I enter my value in and an existing cell value above it. It only stays green background. I have also attached the excel file, the formula should apply to 2015 row, and compared to 2014 row directly above it.
Here is my conditional formatting:
2015-12-22 11_05_29-Conditional Formatting Rules Manager.jpg
Example:
C5 has 1058, and C6 I enter 1185, this cell needs to change to green if the difference is 5% or more increase, change to brown if between 1%-4% increase.
Bookmarks