We’re changing the color of the selected value, which Excel displays in C1. Now, to specify a conditional rule that changes the font color of a list item, do the following: This is where you ...

Can Excel sort by color? Absolutely ... and icons, and using conditional formatting, check out these two past articles: How to use Microsoft Excel’s conditional formatting, and How to customize ...