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

Thanks, it was the AND format that I was looking for, that will work perfectly. thanks I don't know why I didn't think of AND

Actually when I put it the way you have nothing happens, nothing gets coloured? I need to do it similar to how you have it, as I need the conditional format to work for the entire column for when filtering or sorting. If B="Associate" then L gets coloured using light colours based on values. IF B does not ="associate" then L get coloured using dark colours based on values

I figured this out thanks to your help

=AND(NOT($B1="Associate"), $L1<90%)
=AND($B1="Associate", $L1<=10%)

Now the entire column works the way I wanted it to, not sure if this was the best way but it works for me