Percentage Format Rules

[Telpro]

Hello Sir im newbie here,

i have data with percentage format. im gona highlight it

Equal 100% is Green
96% - 98% is Orange
Less 95% is Red

i have try it
[Column Name] = “100%”

Thanks before…

[LeventK · Accepted solution]

@Telpro
Try with this:

For Green
AND([ColumnName] > 0.98,[ColumnName] <= 1.00)

For Orange
AND([ColumnName] >= 0.95,[ColumnName] <= 0.98)

For Red
[ColumnName] < 0.95

[Telpro]

thanks for helping me sir,

but for this didnt work

AND([ColumnName] >= 0.95,[ColumnName] <= 0.98

example some of my data have a decimal value like 99,2%, i have try

AND([ColumnName] >= 0.98, [ColumnName] < 0.1)

But it didnt work, format rules didnt work

[LeventK]

@Telpro
Check this out

[Telpro]

i mean this, i try to edit to 98.2% and the format didnt work

[LeventK]

@Telpro
That’s because your expression does not cover the data points between 98 & 100. Check it now please.

[Telpro]

so whats the best solution for this ?
sorry if i have asking too much, im newbie here

[LeventK]

I have given you the expressions above in my post

LeventK:

@Telpro
Try with this:

For Green
AND([ColumnName] > 0.98,[ColumnName] <= 1.00)

For Orange
AND([ColumnName] >= 0.95,[ColumnName] <= 0.98)

For Red
[ColumnName] < 0.95

[Telpro]

nah im gona change it
100%
98-99%
95-97%
.>95%

can u pls show me the formula for it pls sir ?

[LeventK]

Telpro:

100%
98-99%
95-97%
.>95%

Shouldn’t be the last one <95%? So you need 4 colours?

[Telpro]

ok thanks sir, practice make perfect…