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