Does anyone know how you can format one digit in a cell without formatting the rest without having to do it manually every time ? For example if 53 appears in a cell I would like for the 3 to be red and the 5 remain black. Every time the 3 appears in my data I want the 3 to be red, for instance I type 693 in a cell the 3 should be red and the 69 should stay black. Please help!! I'm new to excel and not familiar with VBA can it be done with a formula?