Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

condition format not working

Hi  Here is my color field rules..but result showing different.can someone help me to solve this?   Thanks Kavitha ghosh
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    you must know that the way the "Percent" conditional formatting works is different than you think, it doesn't have anything to do with percent of total.  It take the lowest and hightest displayed amounts and uses those to determine the formatting bands based on the Percent you entered so your table is looking at these numbers to apply the formatting.

    So for your case, just replace "Percent" with "Number" 

     

    Regards,

    Lin

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Don't use Percent, use Number. I know, it's confusing when you have percents but this comes up quite a bit. Use Number and put in your percentages as decimal numbers.