Is it possible to use conditional formatting on specific text within a cell?
For example, a single cell contains the following: AR, IL, IN, KY, LA, MO, OH, PA, TX
I want to change the font color of certain states based on a lookup list of states that I have. Example: AR, IL, IN, KY, LA, MO, OH, PA, TX
I do not think this is possible with conditional formatting. Any suggestions?
Bookmarks