Hi all,

I just have a simple conditioning formatting question.

I want to be able to turn a cell into a certain color, depending on what I wrote in the cell. For example, any "AA" will be green and any "BB" will be red.

In fact, it'll be even better if there's another way where I can make a list (on another sheet or whatnot) that has a list of all terms that I want to turn into green (cell color) and ones that I want to turn into red (cell color). For example, there's a place where I list all the terms that I want to be highlighted in green and excel can just pull from that list and turn my my cells that has any of those terms in that list to green (on another sheet of course). If this is not possible, I guess I'd have to set the condition one by one based on the text.

Thanks!
Maven