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