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.

Thanks to the linked cell property in Microsoft Excel, it's super easy to use the selected value as a condition in a macro or conditional formatting rule.