Formatting background of alternate rows

Hi
I’ve got a pivot table and I need to demark each week row e.g. white background for week 1, grey for week 2, white for week 3. I can affect the backgrounds with Conditional Formatting on the Value columns but I can’t find a way to do it for the Row columns: is it possible and if so, how? Ideally the colour would span the Row details similar to the below mock up.

image

Thanks
Richard

Hi RichardAustin,

For pivot tables, the conditional formatting selection is limited to the measures that are in the Values field well.

Hi Peter

I suspected as much, thanks for taking the time to reply.

Richard

CivSig_e5feab53-f6b3-452c-9daa-637ba165359a.png

web2020_eb810f1a-c75e-419b-b4e7-e58c44d8ff89.png

twitter2020_27d24012-b5e1-4a5f-8612-ccc15811a79a.png

linkedin2020_152c882a-0a70-44eb-97b8-9121e53b0fb5.png

1 Like