Multiple Conditional Formatting

[young engineer]

Hi All
I want to do a two conditional formatiing on the same column. I have a dropdown button with two choices in another column, and based on what I have selected, I want to have another column conditionally formatted for that.

For:
Column A1 = F-95 >95 = green
<95 = orange
<90 = red


Column A1 = F-90 >90 = green
<90 = red


I can format for the first selection, but how do I do it for the next selection.

 

[Sal Paradise]

Please post examples. Or at least explain without using super-ambiguous explanations like:
"I have a dropdown button with two choices in another column, and based on what I have selected, I want to have another column conditionally formatted for that."

Are the two 'another columns' really the 'same column' from the preceding sentence? Because you've lost me.