Hi there,
When all rows are expended, the conditional formatting will apply properly. However, when collapse any row, the conditional formatting is gone. I saw this Q&A thread but in my case I need to use Fill type Gradient (not Solid as per older thread.)
For Gradient I have no option to apply conditional formatting to Values, Totals and Subtotals.