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.

In this post, we will show you how to change the default color, shape and font of a comment box in Excel. Microsoft Excel allows you to add comments to cells within worksheets.