Colorindex 2 vs -4142

[chuckf201]

I'm using Excel 2016 and I'm using VBA to get the colorindex of cells using
LeftColorIndex = wshScores.Range("D" & lRow).Offset(0, -1).Interior.ColorIndex
in a "for loop".
The sheet is set to not show grids.
Some blank cells return colorindex=2 and other show colorindex = -4142.
Visually they're 'white' but am I missing something.
What is the difference?

Thanks
Chuck

 

[NARAYANK991]

Hi ,

Because you have the grid lines turned off , the difference is not apparent.

If the grid lines were turned on , you would see that the cell which returned the value of 2 for the colorindex , would be missing the grid lines.

2 is returned by the ColorIndex property when a cell has been formatted with a background color of white.

-4142 , which is the value of the VBA constant xlNone , is the value returned when a cell has no color formatting i.e. if a cell has not been formatted for any color. Visually this will be the same color as a cell which has been formatted with a background color of white.

 

[chuckf201]

OK. Makes sense. Can I assume the out of the box, background is -4142?

 

[NARAYANK991]

Hi ,

Yes. The default background formatting for all worksheet cells would be -4142.

 

[chuckf201]

Thanks so much for your help.