VBA function which returs colored result depending on the value

[tmkk]

Hi,

Is it possible to create a function, which result would be colord depending on the value?

Let's say that I want my function to refer to the A1 Cell. A1 value is 0,9 and the result should be simply 0,9 but it should also be colored green (because it's higher than 0,5). I don't want to use conditional formatting here, because this function will be nested nextly in text like below:

="the value is " & XXX(A1) & " and it is below the target" - and I would like only the result of function XXX to be colored.

Thanks in advance for all your support!

[berlan]

You could try numberformatting for the coloring, like:

"[Green][>5]"the values is" 0 "and it's ...";General"

provided the cell is a pure number and the text would be part of the its numberformat

[tmkk]

Do you mean something like below:

Capture.PNG

I think that I entered it incorrectly, because it's not working

One more question, would it be possible to include more conditions this way? <0,2 - Red, <0,5 - Yello, >0,5 - Green?

[berlan]

Try C1 as a pure number with no text in it (text will be in the number formatting), =A1

and work with the number formatting, like:

[Red][<0.2]"the values is" 0.0 "and it's below 0.2";[Green][>0.5]"the values is" 0.0 "and it's below the target";[Yellow]"the values is" General

See attached.

[tmkk]

Thank you for your fast replies. But what I would like to have is only the value of cell A1 colored, not the whole text. So for example I would like to have "45%" (please see below picture) colored.

Capture.PNG


Would it be possible?