How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.