Conditional Formating

[bethi]

Hello - I am looking to conditionally format, in a pivot table, a cell based on whether it is more or less than the month before. Sounds simple enough, right? Wrong (at least for me)!


My dataset lists the item in rows, the months in columns, and the sum of quantity in the values.


I want to say, "if the qty of item xyz for February is greater than the qty of xyz for January, color that green." On the reverse side, I want to say "if the qty of item xyz for February is less than the qty of xyz for January, color that red."

ITEM	JAN-17 QTY	FEB 17 QTY	MAR 17 QTY	APR 17 QTY
XYZ	24	74	35	30
ABC	50	25	20	15
EFG	60	88	90	100
HIJ	50	25	75	50

<tbody>
</tbody>

Thank you in advance for your assistance.

 

[Special-K99]

People alway do this.

What happens if it's equal ?
Based on your logic so far it will won't colour the cell green or yellow.

 

[Special-K99]

With ITEM in A1

Select C2:E5

=(C2 > B2)
format as green

=(C2 < B2)
format as yellow

(remove spaces from the above formulas, forum restriction forced me to enter them)

Adjust the cell references based on where you have the table, ie if ITEM is not in A1

 

[bethi]

Good point! I'm fairly new to the world of conditional formatting, I stumbled upon it by accident, so I am not certain what I would have it do is there is no change. I would welcome any suggestions though

 

[bethi]

Thank you SO much! Your instructions were very easy to follow, and I was able to get it set up in no time.

Thanks again!