# Thread: Conditional Formatting for negative Percentages

1. Registered User
Join Date
Jul 2015
Posts
52

## Answered: Conditional Formatting for negative Percentages

I can not get the conditional formatting for a negative percentage to work.

It works fine for normal numbers, negative numbers, even a positive percentage.

Any ideas?

## "the formatignm shoudl take place after the conditional rule is applied, but if you must deal with text / string repreentations then if(left(value,1)) = "-" ....format as negative if(left(value,1)) <> "-" ..format as positive but Im pretty certain the 'right' way to do it is to calculate the value, then apply the conditional formatting and the control afterwards applies the format"

Join Date
Nov 2004
Location
out on a limb
Posts
13,692
So what have you tried?

4. Registered User
Join Date
Jul 2015
Posts
52
I was just typing my reply when I thought of the answer to my problem. When its a negative percentage you have to do a greater than operator.
see screenshot Sometimes the littlest things can stump you.

5. Registered User
Join Date
Jul 2015
Posts
52
Wait.... nevermind, it was going in the order of rules.... it still doesn't work

Join Date
Nov 2004
Location
out on a limb
Posts
13,692
so you want green % to be positive, red to be negative
there's various ways of achieving that
value >= 0 set to green
value < 0 set to red

7. Registered User
Join Date
Jul 2015
Posts
52
YES, that works for numbers not formatted as a percentage. I want to find out how to make this work for a number formated as a percentage. I can get this to work on positive percentages, like 3.9% but it does not work for a negative percentage like -3.9%

Join Date
Nov 2004
Location
out on a limb
Posts
13,692
the formatignm shoudl take place after the conditional rule is applied, but if you must deal with text / string repreentations then

if(left(value,1)) = "-"
....format as negative
if(left(value,1)) <> "-"
..format as positive

but Im pretty certain the 'right' way to do it is to calculate the value, then apply the conditional formatting and the control afterwards applies the format

9. Registered User
Join Date
Jul 2015
Posts
52
OH OK..... I see now, I was formatting in my expression and not the control. it works!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•