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! Go to 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
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
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
@Telpro
Check this out
i mean this, i try to edit to 98.2% and the format didnt work
@Telpro
Thatโs because your expression does not cover the data points between 98 & 100. Check it now please.
so whats the best solution for this ?
sorry if i have asking too much, im newbie here
I have given you the expressions above in my post
nah im gona change it
100%
98-99%
95-97%
.>95%
can u pls show me the formula for it pls sir ?
Shouldnโt be the last one <95%? So you need 4 colours?
ok thanks sir, practice make perfectโฆ
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |