Alternating Column Row colors based on Year

[michellesogge]

Hello, 

I am trying to create a table that clearly shows which data points fall under different years via color-coding. I currently have a matrix set up with the following:

What I would like to do is alternate colors based on the Year. For example, both the "%" and "#" values for 2019 and 2021 would be a light grey background throughout the entire matrix, while the values for 2018, 2020, and 2022 would be white. Is there a way to do this?

[SivaMani]

@michellesogge, You can have a format by column, In your case, technically year is not a column - it is just values displayed in that format. You can format visuals by "%" and "#" values.  But it will apply for all years.

 If you have the Year as rows, you could try conditional formatting.

[michellesogge]

Ah, I see! Yes I had played around with that but ran into the problem you identified above. So there isn't a way to have it only do that for alternating years? Unfortunately there are too many current row values (I only showed some of them here) to have the years be switched to rows.