Forum Discussion

rnelsch's avatar
rnelsch
Copper Contributor
Aug 03, 2022

IFTHEN by Color? Is it possible?

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.?  

Formulas and Functions

2 Replies

  • Jagodragon's avatar
    Jagodragon
    Iron Contributor
    Aug 03, 2022
    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.
    • rnelsch's avatar
      rnelsch
      Copper Contributor
      Aug 03, 2022
      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.