# Color-coding Cells in a Pivot Table **URL:** \ **Category:** Forms, Views, and Interfaces\ **Created:** [July 26, 2024, 9:00am UTC](https://air.tableforums.com/t/color-coding-cells-in-a-pivot-table/1267 "2024-07-26T09:00:31Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![JBJ](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/jbj/32/1063_2.png) [@JBJ](https://air.tableforums.com/u/JBJ)\ **Post date:** [July 26, 2024, 9:00am UTC](https://air.tableforums.com/t/color-coding-cells-in-a-pivot-table/1267/1 "2024-07-26T09:00:31Z")
On a dashboard interface, I have a pivot table that counts the number of times a parameter (e.g. the ticket price for the exhibition) was mentioned by visitors in their reviews and I have those counts be computed for each venue (see Attachment #1). I would like to have cells be color-coded depending on their value: shades of green for the Strengths pivot table, shades of red for the Weaknesses pivot table. Unless I’m mistaken, as yet it’s not possible to get this visualization feature on Airtable. Would you have any workaround to suggest? ![Pivot Table on Airtable](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/2X/9/995d19fddba74003fa3f7cdfdb35ac13e30b3990.png) Similarly, I’d like to get the same formatting on the table that’s displayed on the PDF report that gets generated by Documint (see attachment #2). Any other PDF-generating tool to suggest that would allow me to get this color-coding? ![Pivot Table on Documint](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/2X/3/30f2bf89776659d4a3e75bc7222c689106e8c7af.png) ---
**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\ **Post date:** [August 14, 2024, 8:35am UTC](https://air.tableforums.com/t/color-coding-cells-in-a-pivot-table/1267/2 "2024-08-14T08:35:38Z")
@JBJ You are correct that Airtable does not allow you to add colors to the cells in pivot tables. Google Sheets does a great job with both both pivot tables and conditional color formatting, so I would recommend doing this with [Make’s Google Sheets automations](https://www.make.com/en/integrations/google-sheers?pc=scottworld) and [Make’s Airtable automations](https://www.make.com/en/integrations/airtable?pc=scottworld). You would typically setup the automation to dump all the necessary Airtable data onto its own tab in Google Sheets, and then on another tab in Google Sheets, you would have the pivot table that automatically generates itself from the dumped data. You would also set the conditional formatting there as well. Below is a screenshot of a very simple way to set this up in Make, but this is just a very simple example of how you could do this in Make. Most of my Make scenarios are significantly more complex than this, but this would be a good starting point for you. This scenario creates the new spreadsheet, searches for specific records in Airtable, and then adds each record as a new row in the spreadsheet. (Make automatically loops through your found records, so you don’t need to specify any iterations.) ![Screenshot 2024-08-14 at 10.32.03 AM](https://canada1.discourse-cdn.com/flex029/uploads/tableforums/original/2X/4/4ebc6c558055520d7330df75f1b03c7f3b790bd9.png) If you’ve never used [Make](https://www.make.com/en?pc=scottworld) before, I’ve assembled a bunch of Make training resources in this thread: > [@Make.com - Basic Training & Navigation Tips](https://air.tableforums.com/t/make-com-basic-navigation-tips/277): > > Hi everybody! I created a [Loom video at this link](https://www.loom.com/share/384a477202764f8d9de9a086fda9a3b1?sid=05af36ce-b757-4d27-95df-6159f3736a1d) to show off some basic navigation tips for [Make’s advanced automations & integrations](https://www.make.com/en?pc=scottworld). There are a few hidden gems in here that you might not have previously known about. Some of the tips that I cover in this video: You can move modules around in any order that you want. You just need to unlink them by right-clicking on the path, and then relink them by dragging. You can make a different module the very first module by dragging the little… For example, here is how you would instantly trigger a Make automation from Airtable. > [@Instantly trigger a Make.com automation from Airtable (i.e. sending Airtable data to an external webhook such as Make.com)](https://air.tableforums.com/t/sending-airtable-data-to-an-external-webhook-such-as-make-com/159): > > If you’d like to trigger a webhook in an external service (such as [my favorite automation tool Make](https://www.make.com/en?pc=scottworld)), you can easily do this by creating a formula field or a button field that combines the webhook URL + any parameters that you want to send to the webhook. So, for example, if your webhook URL is https://your\_webhook\_address.com, and you want to send it your RecordID, you would create a formula field or a button field with a formula that looks like this: "https://your\_webhook\_address.com?RecordI… — ScottWorld, [Expert Airtable Consultant](https://www.scottworld.com/airtable)