the statement cells.Interior.ColorIndex = xlNone
will clear a color pattern but does not seem to work on one that was set
using the ISBLANK statment in an earlier sheet. using format/cells also does
not clear the pattern. do i need to delete sheet contents to erase a color
pattern

thanks