Good morning all,
After some help please,
I have a pivot table that plots a value in a cell of when our stock will last to(columns "D" onward are grouped as months/quarters/years.
What I would like to do, which I have no idea how to, is highlight each row up to the point the value is displayed in the pivot table.
Obviously its easy to highlight that cell , but I have no idea where to start on highlighting the row up to that point.
Any help, very very much appreciated! Thank you,
Kind regards
Mark
After some help please,
I have a pivot table that plots a value in a cell of when our stock will last to(columns "D" onward are grouped as months/quarters/years.
What I would like to do, which I have no idea how to, is highlight each row up to the point the value is displayed in the pivot table.
Obviously its easy to highlight that cell , but I have no idea where to start on highlighting the row up to that point.
Any help, very very much appreciated! Thank you,
Kind regards
Mark
