I would like to highlight and color text based on its value ie
“First” = Red
“Second” = Blue
“Third” = Green
the only way I can find and think of now is adding another column and mapping the strings to numerical values. I don’t really want to do it that way, is it possible to have conditional formatting based on the text itself?