Pivot table/conditional formatting

[chally3]

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