Discussion Locked
0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have some calculations to find the percentage of the sum of some figures, This can be a negative percentage I need to have these figures in Red I have tried Cond Formatting to say if less than 0 then text is red but this does nothing what am I doing wrong
4 replies
by nuinfluences
#,##0;-#,##0[Red] Is the format I have used in the text box to turn the normal numbers Red but how do I do it with the percentages ??
Thanks In Advance
by bob sellman
Use the same format, but include a percentage sign. For example, if you want one decimal place and no commas:
#.00%;#.00%[Red]
If you want commas and no decimal places:
#,###%;#,###%[Red]
Note that this takes the value and converts it to a percentage, so .55 becomes 55%.
by nuinfluences
That did the trick Thank you very much saved me a lot of time Cheers Bob
by nuinfluences
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies