Pivot Table with Conditions Format

I have a pivot table that has 5 columns (Customer, 2009, 2010, 2011, 2012). Customers may buy from us each of the 4 years or every other year. Their purchases all depend. I am looking it add conditional formatting so that cell is highlighted if there is a value in the prior year, but not in the current year. I have uploaded some hard coded sample data.

Prior Year has a value, but current year does not.
Conditional-FOrmatting.xlsx
Michael FranzCFOAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NBVCConnect With a Mentor Commented:
Select column C:E, then go to Home|Conditional Formatting|New Rule

Select use a formula to determine which cells to format

Enter formula: =AND(ISNUMBER(B1),B1>0,C1=0)

click Format and choosed from Fill tab.
0
 
Michael FranzCFOAuthor Commented:
It worked great. The only change I had to make was the C1=0 to C1=""..... Awesome!
0
All Courses

From novice to tech pro — start learning today.