Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
We use the following formula:
="Stu/W: " & TEXT((A$2/B2),"[Red]#,###,##0.00") &"€"
and wish to have the resulting negative currency numbers colored red and positive blue.
Unfortunately neither this or other combinations we tried works. Neither did we find a solution using Conditional Formatting.
How can we have the resulting negative currency numbers colored red as well as the positive blue?
There is no way to pull this off automatically in Google Sheets with formulas, conditional rules nor even with a script. Multicolour text is not supported to be achieved other than setting it up manually on non-formula output.
But if you really want:
Which isn't so pretty so one drawing per row with a white background would look like this:
