One way
Formatconditional formatformula is=a1="great"<select formating
Adjust cell location as required
HTH


"anton" wrote:

I would like to have a cell that says "great" and is colored purple to
appear the same way whenever I type the word "great"