Imagine that I have rows 10 - 100 where the cells either have no color or a color of blue.
I'd like to add a macro that will turn the clear cells into red (for instance).
It would be neat if the following worked:
sheetname.range(startRow, endRow).Interior.ColorIndex = red AND blue (or red NOT blue, etc)
The thought would be if the cell was blue it'd stay blue else red.
Don't want to loop through each row and determine if it is blue and then make it red if not... have too many columns to do this with.