Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a pivot table and I would like to color the table with stripes.
I am using the following expression:
=if(Even(RowNo(TOTAL)), LightGray())
But it doesn't work for null values. Could somebody help me out?
Thanks in advance!
Cheers,
Inês
ttry this
lik below
=IF(Even(RowNo()),RGB(245,245,245),White())
Hi,
Try something below:
=if( BalancePosition='Cash Flow from Operations',LightGray(150))
Thanks,
AS
Hi,
Check this in pivot table -> properties -> Style -> Stripes Every ->
HTH,
Hirish
Hi, unfortunately I can't select that option (I don't know why, but I am not allowed to clik there).
Thanks for your reply.
Cheers,
Inês
Sorry, I don't get it. What are BalancePosition and Cash Flow from operations supposed to be?
Thanks,
Inês
Doesn't work
Thanks for your reply.
Inês
That was just for example, you need to change based on your Dimension.
Thanks
AS
Click on the current style > and select the color format that you need and then you will be able to select the number of strip rows