I have an Excel sheet in which many cells have been highlighted using built-in conditional formatting commands. If I try to change the cell color or fill by traditional means, I can neither change the non-filled cells to being filled, nor can I change the filled cells to being non-filled (the sheet is not locked, it's just that changing the color using these has no effect). I can turn a filled cell "blank" by removing conditional formatting from the cell. Basically, I am trying to scan through the entire sheet and check each cell for whether or not it is colored, but I don't know the cell property to address for this particular case of formatting. I would greatly appreciate any help! Thanks.
Cells(x,y).DisplayFormat.Interior.Color
or.ColorIndex
to retrieve the color fill attribute - Kubie