Remove Cell Color after Code is Deleted
 

Hello: I added some code on an Excel tab to highlight the active
row. It worked fine, but I decided that I did not want this feature
on my project...so I deleted the code.

My problem is that the last row highlighted by the code remains
highlighed and I cannot seem to change the fill back to normal.

Any suggestions? What is controlling the color at this point since
the code has been removed?

Thanks!

Remove Cell Color after Code is Deleted
 

Anyone have a suggestion? It is strange because I cannot change the
highlighting back to normal (no fill or white) with the format cell
commands.

Thanks!

Remove Cell Color after Code is Deleted
 

Can you change fill color on all other rows/cells?

Post the code you used to color the active row/cell.

Although I would think that should not prevent making changes, but who knows
what evil lurks in the shadows.

Especially with Excel and its idiosyncratic behaviour at times.


Gord Dibben MS Excel MVP


On 16 Feb 2007 13:41:22 -0800, wrote:

Anyone have a suggestion? It is strange because I cannot change the
highlighting back to normal (no fill or white) with the format cell
commands.

Thanks!

Remove Cell Color after Code is Deleted
 

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.

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.