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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.