View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jaxstraww jaxstraww is offline
external usenet poster
 
Posts: 15
Default Formatting Certain Words

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