Forum Discussion
Kelly Horst
Jun 25, 2018Copper Contributor
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
- SergeiBaklanDiamond Contributor
Hi Kelly,
That's only with VBA if you are ready to work with macros.