Custom number format in Excel lets you define the color of the text in selected cells according to their values. What's more, ...

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 ...

See the screenshot below. To color-code specific text, select the cells that contain (or will contain) the text that you want color-coded. In the example above, I have selected cells B2:B27. At this ...