Percentage Format Rules

Telpro
New Member

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…

Solved Solved
0 10 695
1 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

View solution in original post

10 REPLIES 10
Top Labels in this Space