I have a feeling I'm missing something very simple, like a bracket or quotation or maybe I'm defining my cell area wrong or something. Almost like I have something overriding it but I'm trying a new sheet each time. Just copy and pasted the whole thing, even named my conditional formatting rule "_highlight" just like his page, and nothing seems to be working. With this one I replicated the exact page that was offered as an attachment by acknak, using the exact same word criteria even. I've even tried what's mentioned at this thread: viewtopic.php?t=30992 and it's not working for me at all. I have tried the above method every way I can think of and I simply cannot get it to work. So if a sell contains "heirloom seeds" or "heirloom veggies" both would highlight under the same conditional formatting rule for the word "heirloom". I want it to work even it the cell contains other words. I want to have conditional formatting for a column (say column a) that will highlight every cell in that column that contains a word (say heirloom) with a specific color (say yellow). Ok, I am having the exact same issue as the thread was originally posted for. New here but been using your suggestions without an account for years and they've all worked flawlessly until this one so I never needed to post.
0 Comments
Leave a Reply. |