Helpful example showing how to conditionally format using a formula

https://support.office.com/en-us/article/Use-a-formula-to-apply-conditional-formatting-FED60DFA-1D3F-4E13-9ECB-F1951FF89D7F

Even better link showing how to do ANDs and the like:
https://support.office.com/en-us/article/Create-conditional-formulas-to-find-data-or-apply-formatting-5CDFB6A3-75FF-48C3-B11F-C15F9563722D