Conditional formatting for different answers?

B

Bal_Ocado

New Member
Joined
Dec 18, 2013
Messages
39
Hey Guys,

I've got a pivot table infront of me and just wondering if this is possible. Pivot table columns go as:

Mechanic - Brand - Pack - Account

I need all of these as they are. The next column is months.

After this I have financials. I want to create a conditional format where financials are highlighted if the same Mechanic - Brand - Pack - Account combo has differences in financials by month.

Is this possible??
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
You must log in or register to reply here.

Similar threads

S
  • Solved
Conditional Formatting for when the month/year date for the same ID on two worksheets doesn't match
Replies
7
Views
126
etaf
etaf
rjbinney
  • Question Question
Columns by Month in Pivot Table
2
Replies
17
Views
831
Alex Blakenburg
A
J
  • Question Question
Conditional formatting of single column of pivot table
Replies
8
Views
233
Peter_SSs
Peter_SSs
Excelwhatsthat
  • Question Question
Scroll enabled to minimise table view...but need conditional formatting
Replies
0
Views
79
Excelwhatsthat
Excelwhatsthat
G
  • Question Question
Conditional Formatting for Various Dates
Replies
4
Views
790
MountainFog
M

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top