Hi Zooming,

Select cell where 'Delete' is. Go to format, conditional format.

select 'Cell value is' 'Equal to', ="delete"

Select the format conditions e.g font color, patten Click OK

If it does not work go back in and check that excel has not added an
extra set of quotation marks - if it has, delete them and click OK.

HTH
Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=526751