# Conditional Formatting **URL:** \ **Category:** Q&A\ **Tags:** analysis, calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [January 27, 2024, 6:19am UTC](https://community.amazonquick.com/t/conditional-formatting/24312 "2024-01-27T06:19:45Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![apjvinod](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@apjvinod](https://community.amazonquick.com/u/apjvinod)\ **Post date:** [January 29, 2024, 3:04am UTC](https://community.amazonquick.com/t/conditional-formatting/24312/2 "2024-01-29T03:04:33Z")
Hi @Mohseen_Alam_Khan if you are trying to compare the actual vs target columns, you probably need to create a calculated field first that finds the difference, and then base your conditional formatting based on the calculated field. Could you please refer to this community post for additional details . > [@Conditional formatting based on column](https://community.amazonquick.com/t/conditional-formatting-based-on-column/4761/2): > > Hi, Pivot table supports conditional formatting. You can format the value part based on any dimension or measure as aggregation. Here is the blog for Quicksight conditional formatting. Hope this helps … it would be helpful if you could share screenshot of issue / create a sample pivot visual in [Arena](https://community.amazonquick.com/t/new-quicksight-arena-an-embedded-instance-of-quicksight-within-the-quicksight-community/21590) for us to check further. Thanks VInod --- _[View the full topic](https://community.amazonquick.com/t/conditional-formatting/24312)._