Conditional formatting from multiple cells.

Hi,

I am trying to create a conditional format but to read to sets of data to determine the colour it will show...

So, the first line "YES" or "NO" and the second a number.

If the cell in row 6 shows "YES" then i would like have the number cell to be filled green below 30, orange between 30-49 and red 50 and above.
If the cell in row 6 shows "NO" then i would like the number cell to be filled green below 20 and red 20 and above.
If the cell in row 6 shows "N/A" then i would like the number cell to be filled green below 20 and red 20 and above.

I have attached a mock sheet for you to see what i am talking about.

I'm not even sure if this is possible...

Hope you can help me on this one.

Thanks in advance!