1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter your formula

If you want to test for more than 1 condition, just add more rules