Thread: Alternative to Conditional Formatting
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
simtug simtug is offline
external usenet poster
  
Posts: 1
Default Alternative to Conditional Formatting

Here is a subsequent issue... using the VBA code

If UCase(Target.Value) = "text" Then
Target.Interior.ColorIndex = 23

Whenever I press the DEL key to delete the content of the cell, a 13
runtime error pops up.

How can I make sure this does not occur?


--
simtug
------------------------------------------------------------------------
simtug's Profile: http://www.excelforum.com/member.php...o&userid=28255
View this thread: http://www.excelforum.com/showthread...hreadid=477742

Reply With QuoteReply With Quote