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:
| Device | A1 | |
|
Operation |
| plan | fact |
|
1 | | 25.01.2012 | 01.03.2012 |
|
2 | | 26.01.2012 | 04.03.2012 |
|
3 | | 20.01.2012 | 28.02.2012 |
|
4 | | 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.