Is it possible to exceed the standard 56 interior colorindex of a cell? I know you can modify/customize the color pallet but wanted to use code (see below) to visually see the color as well as it's index.
For i = 1 To 56
ActiveCell.Offset(0, 1) = i
ActiveCell.Interior.ColorIndex = ActiveCell.Offset(0, 1)