Matrix conditional formatting for column total only

[admin_xlsior]

Hi,

For matrix conditional formatting, can we choose to which Total it will apply ? the options now is Total only but no selection to which total. Is there a trick to do so ?

Because I have format like this :

This it self already bugging me since I don't want the Row total to be coloured (formatted) also, only the Column total on the rightmost.

Then if we expand the month, it will become more 'ugly' ->

Else can I have some advice to make this report more attractive but not hurting my eyes.. 😅

Thanks,

[jdbuchanan71 · Accepted solution]

@admin_xlsior 

you should be able to use something like 

Blue Formatting = IF ( ISINSCOPE ( Calendar[Quarter] ), BLANK(), "#B0D0E2" )

which should leave all columns but the row totals (on the far right, those are row totals) blank.  You will need to update the table and field names to match your model.