Hi All,
In my pivot Table, I have dates in Col A.
Is it possible to highlight the entire row corresponding to the latest date?
I tried $A14 = MAX(DATE(2014,8,1),DATE(2014,9,1),DATE(2014,10,1),DATE(2014,11,1),DATE(2014,12,1),DATE(2015,1,1),DATE(2015,2,1),DATE(2015,3,1)).
But not working.
Thanks.