Sticky interior colors

D

David Portwood

From within a macro I'm trying to set the interior color of cells based on
their value, but I notice that cells which are already colored won't change.
Even manually they won't change. If I first clear format in the cells then
it works.

Does this sound familiar to anyone? I don't want to first clear formats
because other formats get lost. Any suggestions?

David Portwood
 
T

Tim Williams

If you can't change the existing colors you may have Conditional Formatting
applied to those cells.

Tim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top