Create additional conditional statements by highlighting the same cells, clicking the "Conditional Formatting" button again and making another selection. Save the workbook when you are finished.

How to Use If-Then Excel Equations to Color Cells. If-Then rules allow you to create colorful business spreadsheets that do more than look pretty. Meaningful colors can help you and others ...

For instance, you can use conditional formatting to highlight cells in red if their values fall below a certain number or use another color for values above a target. It can also be applied to ...

[Conditional formatting] allows Excel to apply a defined format to cells that meet specific criteria. You can use a different background color, font color or border.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.

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.

Can Excel sort by color? Absolutely. In addition to sorting by values, Excel can sort by cell color, font color, and cell icon. First, you must you must define the colors for your sort columns/fields.