Thread: selection to color cell if the word promise is in cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DKY[_119_] DKY[_119_] is offline
external usenet poster
  
Posts: 1
Default selection to color cell if the word promise is in cell

Best I could come up with for conditional formatting:
Formula Is
Code:
--------------------
=SEARCH("promise",$K2)0
--------------------

Then copy the format all the way down the column, that seems to work.
Thanks for the help all.


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=553243

Reply With QuoteReply With Quote