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"

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"

Use conditional formatting, select the range of cells wheer you want
"great" to be coloured purple, then from the format menu select
conditional formatting, leave condition 1 as "Cell value is" from the
next drop down select equal to, in the third box type great and then
click on the format button and select the format you want


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390970

Perfect! Thank you

"Paul Sheppard" wrote:


Use conditional formatting, select the range of cells wheer you want
"great" to be coloured purple, then from the format menu select
conditional formatting, leave condition 1 as "Cell value is" from the
next drop down select equal to, in the third box type great and then
click on the format button and select the format you want


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390970