IFTHEN by Color? Is it possible?

Occasional Contributor

Is it possible to do an IFTHEN by the color of the text? For example, if the text is Blue I want the cell to say "Vendor", if the text is green I want it to say "Permit" etc.?  

2 Replies
Have you checked this? https://stackoverflow.com/questions/26949079/vba-to-find-the-font-color-of-a-string It appears to answer your question with two good options.
I'm a little hesitant to click on links, no offense. I did not get on Stack, searched on this forum didn't see anything. But I figured out how to sort by Font color and that helped me solve my problem.