View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Remove Cell Color after Code is Deleted

Might have been easier to clear the CF for that row instead of deleting the
entire row.

Gord

On 20 Feb 2007 10:54:59 -0800, "Zack S." wrote:

Hi,
I wanted to follow up on this. After I deleted the code, the
highlighting remained via conditional formatting on every cell, for
the entire row. My workaround was to delete the subject row (which I
wanted to avoid). The code contained language that highlighted a row
only if it contained data...hence the conditional formatting. Thanks
for the suggestion, Gord.