Conditional Formatting using pre-defined RAG thresholds

Hi,

I am new to Power BI and we are migrating from another BI tool to Power BI.

We have a requirement:

Transaction Table:

ID, Value

1,10

1,20

1,15

2,10

3,15

3,22

RAG Threshold:

ID, Green Low, Green High, Amber Low, Amber High, Red Low, Red High

1,0,10,11,30,31,9999

2,0,5,6,20,21,9999

3,0,1,2,5,6,9999

When I so a summerized count against the ID, based on the corresponding RAG threshold we want to change the font color to Green, Amber or Red,

1, 45 (Shown in Red)

2, 10 (Shown in Amber)

3, 37 (Shown in Red)

How do I achieve this?  Tried reading through conditional formatting and can't find any lead on how to set the threshold values using another column values

Thanks

Raj