Forum Discussion
vishnu4646
Sep 12, 2022Copper Contributor
MS Excel: Change colour of formula's output
I have a requirement to change the text of formula's output. I tried many ways however entire cell colour is getting change not specific text. So the formula is like below, combination on text and m...
OliverScheurich
Sep 12, 2022Gold Contributor
This can (only ?) be done with Range.Characters(...,...).Font.Color in VBA.
vishnu4646
Sep 12, 2022Copper Contributor
OliverScheurich, do you have any reference link or example that I can refer?
- OliverScheurichSep 12, 2022Gold Contributor
Range.Characters property (Excel) | Microsoft Docs
If i correctly understand this is your expected result:
- vishnu4646Sep 12, 2022Copper Contributor
Yes, it will will work Quadruple_Pawn !