[Solved] Formatting output according to value

[JohnPowers]

Hi there, wise ones! I hope someone can help me with a rather obscure request I got from a client I do some occasional stuff for. They would like to have the output format in their spreadsheet dependant on the value in the cell. I have no idea how to do this, or even if it is possible! So for instance, what they want me to do is to stick in, say cell D4, a value like:

=IF(A4 < 10; "Y"[in green]; "N"[in red] )

Is this even possible? If not, can anybody think of a clever workaround to achieve a similar looking effect? Thanks for any help - John

[FJCC]

You do this sort of thing with conditional formatting. In the attached file, I defined two cell styles called red and green that differ from the Default style only in the font color. I applied the red style to D4. I set up conditional formatting on the cell (menu Format -> Conditional Formatting) to apply the green style if the cell value is "Y". The formula in D4 controls whether the cell shows an N or a Y.
There are many possible variations on that strategy.

[Villeroy]

Since you are using an IF formula anyway, you can combine it with function STYLE.
In FJCC's file:

Code: Select all

=IF(A4 < 10; "Y"&T(STYLE("green")); "N"&T(STYLE("red")))

[JohnPowers]

This does it - huge thanks.. I followed FJCC's advice and it does exactly what I needed here. In fact, by then I had it fixed, before I noticed Villeroy's additional short cut, but I will keep that in mind if I get a similar request. So thanks to both of you for taking the time to respond. - John