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

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History