MS Excel: Change colour of formula's output

Viewed 40

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 multiple formula in one cell only:

="Total amount payable to "&LOOKUP(2,1/(NOT(ISBLANK(H:H))),H:H)&" is "&Total[[#Totals],[Actual]]
Text 1      :  Total amount payable to 
Formula 1.  :  LOOKUP(2,1/(NOT(ISBLANK(H:H)))
Text 2.     :  is
Formula 2.  :  Total[[#Totals],[Actual]]

Text 1 and Text 2 colour would be black and formula 1 and Formula 2 output should change to Green.

How to achieve this?

0 Answers
Related