Formatting Challenge-Microsoft says it can't be done ???

[USMCCOOL2]

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?

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1097007-single-number-2-digit-number-formatting.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).