How to use conditional formatting based on diff cell value

I am having troubles using conditional formatting. My workbook contains particular stores, and their respective associates. I have the associates grouped with their stores so you can expand the store and see individual sales that those associates contribute to the stores.

I want the conditional formatting to show for stores if <90 cell is red, 90-100 then cell is yellow, if it is 100+ cell is green. However when I expand the stores to see associates I want to conditional formatting to be if <10% cell is red, 10<>20% cell is yellow, 20%> cell is green. The associates expand into the stores. Assuming there are 7 or less stores how can I make this work, what if there are more than 7 stores.


this is what I have

Collapsed

D1, StoreName J1, Target K1, Actual Sales L1 Achievement Rate
D7, Store1 J7, 6 K7, 6 L7 100%
D12, Store2 J12, 10 K12,5 L12 50%
D20, Store3 J12,20 K12,0 L12 0%
And so on


Expanded
D1, StoreName J1, Target K1, Actual Sales L1 Achievement Rate
D7, Store1 J7, 6 K7, 6 L7 100%
D8,Associate1 J8, 1 J8, 1 J8 100%
D9, Associate2 J9, 2 J9,1 J8 50%
D12, Store2 J12, 10 K12,5 L12 50%
D20, Store3 J12,20 K12,0 L12 0%

Assume each store has several associates