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 % DiffMy 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?

Try this: =(IFD2>$L$1,TRUE,FALSE) < yours

=IF(D2>$L$1,TRUE,FALSE) < mine

see the difference?

MIKE

I how did I not see that!!! I guess I looked at it too long. Thanks. I bet this will be the easiest one you answer all day.

=IF(D2>$L$1,TRUE,FALSE) < Mike's =D2>$L$1 < mine

see the difference? ;-)

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

DerbyDad03, I was trying not to confuse, but you are correct,

Conditional Formatting needs only for the formula to return a TRUE response.So while both will work, yours is the shorter. ;-)

MIKE

Sometimes I just can't resist a "teaching moment". ;-)

Click Here Before Posting Data or VBA Code --->How To Post Data or Code.

Thanks!! More info!!

Ask Your Question

Weekly Poll