How to bypass the 3 conditional formatting limit by using the IF or OR function?

Hello, How to bypass the 3 conditional formatting limit by using the IF or OR function?

I am editing an .xls file and there is a limit to 3 conditional formatting rule for coloring a cell.

How do I combine the conditions using a formula?

On the test file there are salary grades. When an employee selects a salary grade on the dropdown box I want the adjacent box to turn red.

However there are 5 dropdown choices. How do I use the IF or OR formula on this one?

Please look at the test file.

Thanks

Thanks for the quick reply.

How about if there are 4 conditions? Lets say

SG26&ABOVE, SG24&25, S18/19to22/23, SG10/11to15/16. It seems there is a limit to three? Can you please show me if an IF or and OR formula or any alternatives

Thanks

I mean now I want instead of turning it to red, It will only turn red if any of the 4 salary grade is chosen on the drop down list.
Which is SG26&ABOVE, SG24&25, S18/19to22/23, SG10/11to15/16. If the employee selects Sub-Prof-Level then it will not turn red.

I tried =C12="SG26&ABOVE" then format it to red.
=C12="S18/19to22/23"
=C12="SG10/11to15/16"
=C12="SG24&25"

I am now over the limit. Can you please help me how to combine this so it is only one condition?

thanks

It works thanks. But I encountered a problem. I substitute =AND(C12<>"",C12<>"SG26&ABOVE") cause I want the SG26&above instead of Sub-Prof-Level to turn white but instead it turned everything to red no matter what choice on the dropdown box. May I ask if a new formula is needed?

Thanks again

Perfect! Thank you so much!

Thanks again