What's more, you don't need to repeat the condition in the second argument. Here's what you get when you click "OK." To format cells based on more than two conditions, use conditional formatting.