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?![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
![ROFL :rofl: :rofl:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f923.png)
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
![ROFL :rofl: :rofl:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f923.png)