young engineer
Board Regular
- Joined
- Mar 3, 2009
- Messages
- 100
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.
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.