|I have a report that compares monthly %s. I look to see if there is a difference between the months. If difference is 10% greater or less I look to find out why. My spread sheet looks like this: |
A B C D E F G H I J K
Description Jan Feb % Diff Mar % Diff Arp % Diff May % Diff
My goal is to hide the % Diff columns (D,F,H,J), so you only see the months. I want to conditional format the cells for each month to change colors if it’s 10% higher/lower compared to the previous month. If it is 10% higher or more, change color to blue, if 10% or lower change color to red. I have a formula in all the % Diff columns to see if they are 10% higher/lower compared to the previous month. I am not sure if I am entering the formula correct on the conditional formatting under the “Use a formula to determine which cells to format.” I have selected C2 to enter the formula and have the following formulas entered =(IFD2>$L$1,TRUE,FALSE) formatted to change to blue & =(IFD2<$M$1,TRUE,FALSE) formatted to change to red. (L1=.1 & M1=-.1) But when I hit ok to apply the conditional formatting I get a warning that says “the formula contains an error” I am not too sure how to fix it. Can you lend a hand?