Showing results for 
Search instead for 
Did you mean: 

Custom cell formatting in Pivot

7 - Data Storage
7 - Data Storage

I want a table or pivot table but the cells are full size blocks/tiles that effectively look like this:

The number will be a calculated function ddiff(date, now) but the text "days" needs to appear, the cell should be a box etc..


Is this something i even want to debate tackling...




Community Team Member
Community Team Member

Hello @liamcameron,

Thank you for your question. Do you have any code that you have tried and it's not working? It might be easier for the community to troubleshoot current code than create it brand new.

Have you checked out That can be a good place to try things without impacting your environment. I also found this post which seems like it might have some relevant information that could help move you forward. 


David Raynor (DRay)

8 - Cloud Apps
8 - Cloud Apps


Custom cell formatting in a Pivot table allows users to tailor the appearance of cells based on specific criteria. This can include applying different fonts, colors, borders, and other styling options to highlight important data or improve readability. Users can utilize conditional formatting rules