Forum Discussion
Solved
Format a value as positive or negative within Excel formula
Hello, I am adding automated commentary at the front of my excel report. Does anyone know how disply numbers with a "+" in front of them if it positive? The negative values come out as "-" using ...
As JKPieterse mentioned, it is not possible to color the numbers, but you can change the number format:
="1. UG: "&TEXT(AR16, "+0%;-0%")&" vs. LY ("&TEXT(AS16, "+0%;-0%")&" LW); "&TEXT(AT16, "+0%;-0%")&" vs target ("&TEXT(AU16, "+0;-0")&" AFP+)"
A formula cannot return text with different formatting for individual characters I'm afraid.