Hello. I would like to do conditional formatting for postive/negative numbers so that they appear with a +/- sign and positive numbers are green text and negative numbers are red text. Muito obrigado.
Hello. I would like to do conditional formatting for postive/negative numbers so that they appear with a +/- sign and positive numbers are green text and negative numbers are red text. Muito obrigado.
for positive value =if(a1>0) format green
for negative value = if(a1<0) format red
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Use the following custom formatting:
[Green]+#;[Red]#
What about if I have text in there as well. How can I have the conditional format ignore text?
Thanks
This erases the numbers lol!! I want the + and the - to go in front of the numbers boludo. Thanks.
Actually, they are %'s not numbers. I just need the positive numbers to have a plus sign in front of them. Thanky!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks