Conditional Fomratting

[jtdale0877]

I am creating a spreadsheet that shows where everyone is in my unit. I have created a drop down list that gives 24 options. Column D contains the list and Column E contains the notes. I have created the cf that when the "Available" selection is made, both column D and E in that row turns green. Likewise, if someone is absent, column D and E in that row turns black. My issue is that I have several options which will result in someone turning these two columns red if the option is selected(such as "Hospital","Leave/Pass","Duty", etc.) and several that will turn the two columns yellow ("Staff", "Orderly Room", etc.). Is there a formula that will allow me to list all words that would result in turning both column D and E for that row red (and same for yellow) if the option is selected or do I just need to do the long way and make a conditional formatting for each word? For example, if Hospital is selected from the list in D20, both D20 and E20 will turn red. Likewise, if Available is selected in D21, D21 and E21 will turn green. If Duty is selected in D22, D22 and E22 turn red. If Staff is selected in D23, then D23 and E23 turn yellow, etc. etc. down to D176.

 

[JoeMo]

=OR(D20="Hospital",D20="Leave/Pass",D20="Duty")

 

[jtdale0877]

That worked perfectly! Thank you very much!

 

[JoeMo]

That worked perfectly! Thank you very much!

You are welcome - thanks for the reply.