Conditional formatting for different answers?

Bal_Ocado

New Member
Joined
Dec 18, 2013
Messages
38
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??
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,109,139
Messages
5,527,055
Members
409,741
Latest member
serfr

This Week's Hot Topics

Top