0

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.

enter image description here

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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.