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!