# Conditional Formatting Not Working On % Value

**URL:** <https://community.amazonquick.com/t/conditional-formatting-not-working-on-value/17360>\
**Category:** Q&A\
**Tags:** pivot-table, analysis, calculations, formatting, quick-sight\
**Created:** [August 24, 2023, 9:51am UTC](https://community.amazonquick.com/t/conditional-formatting-not-working-on-value/17360 "2023-08-24T09:51:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ishma](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@Ishma](https://community.amazonquick.com/u/Ishma)\
**Post date:** [August 24, 2023, 9:51am UTC](https://community.amazonquick.com/t/conditional-formatting-not-working-on-value/17360/1 "2023-08-24T09:51:01Z")

</div>

I have created a pivot table and my actual value in the cell is 100.00%

Now with “greater than or equal to” condition with value 95.50 with green color, my actual cell value(100.00%) shall turn to green but instead it’s turning red. What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [August 24, 2023, 12:32pm UTC](https://community.amazonquick.com/t/conditional-formatting-not-working-on-value/17360/2 "2023-08-24T12:32:04Z")

</div>

It needs to be .955.

The actual value is the percent / 100