asked on Compare Pivot Table Columns with Conditional Formatting.
I've got a Pivot Table set up the reviews a set of Projects. I want to highlight a value that is larger than the value in the next column. I know I could just do a formula or an IF statement and hide that, but I want to have something clean and easy.
Here's a screenshot of part of my Pivot Table:
![PrjPivotExample]()
What I want to do is Highlight the value in the "Total at Billing" column if it is larger than the value in the "Rev Budget" column.
In this example Row 12 should be highlighted.
Here's a screenshot of part of my Pivot Table:
What I want to do is Highlight the value in the "Total at Billing" column if it is larger than the value in the "Rev Budget" column. In this example Row 12 should be highlighted.
Microsoft Excel
Last Comment
royhsiao
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
Is there any way to do it without a Macro?
you could use conditional formatting but it will take a while.
ASKER
I've already got Conitional Formatting set up to highlight negative numbers, but instead of Highlight if less than $0 I want to highlight if less than the cell value to the left of the current number. This is a report that will be updated so I don't want any static or frozen references.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
You could try to call the macro when the selection has change or pivot table update
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Call test
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Call test
End Sub