This function allows you to convert VBA colour codes from 1 to 56 (Interior.ColorIndex) to their long value (Interior.Color): Function CouversionCouleurLong(Couleur As Integer) As Long ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that. Image: PixieMe/Shutterstock ...