Measure For conditional formatting

[Anonymous]

Hi 

Here is my data table.I just want add colour codes with the following rules. (95% - 100% = Green , 90-94% = Yellow, below 90 is red).I tried to use the conditional formatting option in the format table.But wrongly showing colour codes... Can someone help me solve this.. Thanks - Kavitha Ghosh

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

You can try this as a workaround.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes It works.Thanks 

[az38]

@Anonymous 

show, please, your Conditional Formatting dialog box

[Anonymous]

[az38]

@Anonymous 

I see numbers, not percent here

[Anonymous]

Hi

 Its not working Even after ichenget to percent..

[Anonymous]

Its not working even after changed to percent.

[az38]

Hi @Anonymous 

if so, Im not sure how do you calculate [Fac IRA] field. it could depends on aggregation

but you can try to change percents to number in Conditional formatting dialog box and set rate as numbers:

0.95-1

0.9-0.95

0-0.9