Creating conditional formatting based on letter in a list. This is for Wordle and I'm trying to highlight with cell color letters that are wrong. So see in image my first two starting words, for this example I've entered CONES and TRAIL as my first two words. So for this example the only correct letters are "O" "A" and "I". So I've entered the wrong letters in column F and will continue to add to column F more wrong letters with additional words.
Anytime I try to use a wrong letter that I put in the list in column F in any cell from A2 -> E26 I want to color the cell Blue. So it would look like this example image. When I enter a new word like CAIRN I want it to automatically format the wrong letters that I will continue to add to column F. I want it to do the same thing with my alphabet from H1 -> AG1
Been a while since I ask anything here and the Moderator Fluff has helped me many times before.
Thanks! I'll check back in a couple hours.
Anytime I try to use a wrong letter that I put in the list in column F in any cell from A2 -> E26 I want to color the cell Blue. So it would look like this example image. When I enter a new word like CAIRN I want it to automatically format the wrong letters that I will continue to add to column F. I want it to do the same thing with my alphabet from H1 -> AG1
Been a while since I ask anything here and the Moderator Fluff has helped me many times before.
Thanks! I'll check back in a couple hours.