conditional color formatting in pivot table

[rajaqliks]

Hi Folks,

I need to greayed out particular column in pivot table please help i am adding the sample qvw 

condition: if(WEEKEND='11/23/2018',rgb(225,225,225)

Result:

[rubenmarin · Accepted solution]

Hi, you can try with:
If(Floor(WEEKEND)=Date('11/23/2018'), RGB(128,128,128))
// Used floor() to remove decimals, weekend is at 23:59:59

But cells without data will remain white until there is some data that relates rows and columns.

[rajaqliks]

Thanks it working like a charm