cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
virakprom Frequent Visitor
Frequent Visitor

Conditional formatting negative numbers red

Anyone know how set Conditional formatting rule on negative numbers to red ? 
I want negative numbers or percentage to red.
I try to set minimum field to blank but it don't allow me to set it.

photo_2019-08-06_11-30-35.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
virakprom Frequent Visitor
Frequent Visitor

Re: Conditional formatting negative numbers red

@jdbuchanan71  
Very appreciate for your effort to me.
Thank for your support.
Now this issue found already. 

This picture at below that I got email from Microsoft
Issue.PNG

15 REPLIES 15
Super User
Super User

Re: Conditional formatting negative numbers red

Hello @virakprom 

You can change the type from percent to number and put a negative amount in the first field.  The formatting below will format negative % from -100% to 0 as red.
negativeformaat.jpg

virakprom Frequent Visitor
Frequent Visitor

Re: Conditional formatting negative numbers red

It isn't working. but I want show percentage not decimalUntitled.png

Tahreem24 Member
Member

Re: Conditional formatting negative numbers red

Hi @virakprom ,

 

Please set the your conditional formatting as per screen shot below and let me know your result:

Capture.PNG

Tahreem24 Member
Member

Re: Conditional formatting negative numbers red

Hi @virakprom,

 

After seeting the comditional formattin as per screen shot below I have got the expected result i.e. negative values in red color.

 

Please mark this answer as a solution If I answered your question!

 

Capture.PNGres.PNG

virakprom Frequent Visitor
Frequent Visitor

Re: Conditional formatting negative numbers red

It still not work. I try to follow like you mention at above.

Untitled.pngUser role administrator.PNG

Tahreem24 Member
Member

Re: Conditional formatting negative numbers red

Hi @virakprom ,

 

Is it possible for you to give me sample of just 5-10 rows of data file so that I can try it at my end?

Not want to real data just create similar data and send file here.

Super User
Super User

Re: Conditional formatting negative numbers red

@virakprom 

In your example -26 % is the same as -.26.  If you format the number with 

Greater than -1 NUMBER and is less than 0 NUMBER that is the same as saying -100% and 0%.

conditionalformatnegatives.jpg

When you use the % setting it is looking at the percentage of your data meaning, if you have 100 data points and pick Less than 50 percent it will format the first 50 data points.

 

virakprom Frequent Visitor
Frequent Visitor

Re: Conditional formatting negative numbers red

Thank all of you contribute to help me solve this issue. but It still not working all your mention above. 
I think It's bug or error on this issue. I need to extra field in order to show red on negative values.
It doesn't make sense, right ? Why it need to add one more field in table in order to work ?
But my requirement don't need it
you can see picture at below

1.png2.PNG

Super User
Super User

Re: Conditional formatting negative numbers red

@virakprom 

Can you show me a screen shot of your rule with greater than -1 (NEGATIVE 1) and NUMBER and less the 0 number.

negativeformat2.jpg

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 180 members 2,061 guests
Please welcome our newest community members: