# Conditional Formatting - Columns **URL:** \ **Category:** Q&A\ **Tags:** pivot-table, feature-request, formatting, Business-Intelligence-Engineer, quick-sight\ **Created:** [May 28, 2024, 4:10pm UTC](https://community.amazonquick.com/t/conditional-formatting-columns/30593 "2024-05-28T16:10:31Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![riley.anderson](https://avatars.discourse-cdn.com/v4/letter/r/8e7dd6/32.png) [@riley.anderson](https://community.amazonquick.com/u/riley.anderson)\ **Post date:** [May 28, 2024, 4:10pm UTC](https://community.amazonquick.com/t/conditional-formatting-columns/30593/1 "2024-05-28T16:10:31Z")
Is it possible for a pivot table visual to have the columns coloured based on their values? Not the traditional conditional formatting based on the count of the value column. Essentially I have a RAG (Red, Amber, Green) visual, with a classification column before it which is just, 1, 2, 3, and 4. Then each of those will have the values of ‘Red’, ‘Amber’, or ‘Green’ in them. Is there anyway for all of ‘Red’ columns to have the background as Red, same for the Amber and Green columns. This is how the visual looks: ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/b/7/b752d52092c437bc2d0c2613e03405c4a4ddc4ae.png) I just want each colour named column to be the colour in which the value is, regardless of the value inside the cell. Any questions or issues and please just ask, many thanks. Riley ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [May 29, 2024, 9:29pm UTC](https://community.amazonquick.com/t/conditional-formatting-columns/30593/2 "2024-05-29T21:29:23Z")
Hello @riley.anderson! I did some testing and I was not able to do this via the conditional formatting options in the console. From what I understand you need a value to apply the color. I will mark this as a feature request on conditional formatting for the Quick Sight team! ---
**Author:** ![WLS-D](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-d/32/36109_2.png) [@WLS-D](https://community.amazonquick.com/u/WLS-D)\ **Post date:** [May 29, 2024, 9:29pm UTC](https://community.amazonquick.com/t/conditional-formatting-columns/30593/3 "2024-05-29T21:29:34Z")