I have an excel sheet that lists members of a department. Next to their name
in column B they need to put yes, no or maybe. As they type their answer I
would like yes to be red, no to go blue and maybe to go green. Can you format
cells based on what answer they put in the cell? So as yes is typed the word
goes to red?

Thanks,

Shane