Forum Discussion
Alternating Column Row colors based on Year
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 ...
SivaMani
Resident Rockstar
Resident Rockstarmichellesogge, 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.
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.