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
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