Forum Discussion
Mark-NY
Jan 23, 2021Copper Contributor
Use nested IF-THEN statements to fill cells with different colors
I need a formula that will look at the selected cells, and depending on the text found, color each one appropriately. I can do this with one text string and one color, but I have multiple text strings, and I'd like to be able to mark each one with its own color. Thanks!
- Of course! I was so stuck on if-then-else, I didn't think of that. Thanks very much!
2 Replies
- Mark-NYCopper ContributorOf course! I was so stuck on if-then-else, I didn't think of that. Thanks very much!