Solved

Pivot Table with Conditions Format

Posted on 2013-06-27
2
401 Views
Last Modified: 2013-06-27
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
0
Comment
Question by:Newbi22
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 500 total points
ID: 39282532
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
 

Author Closing Comment

by:Newbi22
ID: 39282803
It worked great. The only change I had to make was the C1=0 to C1=""..... Awesome!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question