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 ...