Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to highlight the date comparing to the previous date

Hi all!

Can you help me in my question:

I've got a pivot table that is representing the planned date and the fact date:

DeviceA1Operationfact1234


plan
25.01.201201.03.2012
26.01.201204.03.2012
20.01.201228.02.2012
05.03.2012

I want to highlight in black when

plan date<  current date & fact date is missing

and in blue

plan date<  current date&  fact date<=plan date

Please help.

0 Replies