I have multiple table visuals. Need to find some way to batch do conditionally formatting

[AEdmonds1990]

I have volunteered to build some reports for my minigolf league.

Each tournament consists of multiple rounds. The data for each round is identically formatted. As well as some other more interesting visuals, I would also like to display the raw scores for each round, with some conditionally formatting on the columns.

I would really like to avoid having to do the conditionally formatting manually on each column 1 at a time (this would take over ten hours). Can anyone offer any ideas please? I will explain what I mean below.

These are the raw scores for Round 1 (I changed the names):

Here I applied conditional formatting to each column individually. Each column has a simple rule for its background colour.

These are the raw scores for Round 2:

The format of the underlying data is identical. The other thing that has changed are the values. As you can see I began applying the conditional formatting to column individually. But I gave up.

I can think of two potential options here:

A) Format painter

Unfortunately when I select one visual, press the format painter button and select another visual, it actually removes all of the formatting on the second visual, rather than format painting the columns' conditionally formatting.

B) Change the data source for each visual

Because the visual for each round it based from data which looks identical (just with different values), it would be good if I could simply copy a visual and change the data source for just that new visual. But I don't think there is any way to do this.

[ppm1 · Accepted solution]

One way would be to unpivot your columns and then use that Attribute column in a matrix visual to pivot it back out. You can then apply conditional formatting to the measure used for values and it will apply to all "columns".

Pat