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.