Forum Discussion

Kelly Horst's avatar
Kelly Horst
Copper Contributor
Jun 25, 2018

Color Coding Using Conditional Formatting

Hello, I have an Excel file that has numerous cells that contain alpha/numeric values.  i.e. CLAA09IO1.

How would I format those individual cells so that the 0 (zero) and 1 (one) are changed in color (Red) and (Bold), to differentiate between the letter O and the upper case I, respectively?  i.e. CLAA09IO1 (sorry, but this example isn't showing the 0 and 1 in red).

 

Regards,

 

Kelly

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Kelly,

     

    That's only with VBA if you are ready to work with macros.

Resources