Forum Discussion
How to change a string color using vba
Hi, I'm printing a code using some vba functions and I need that the color of the last 6 digits of that code (UDI string) be red, colud some one help me please? Ex: result of the genUDI fuction - ...
It is not possible to color part of the result of a formula. Excel simply doesn't work that way.
You'd have to replace the result of the formula with its value, then color the last six digits.
But the cell wouldn't be updated anymore if the cell(s) that the formula referred to change...