Forum Discussion
Row by row Conditional Formatting on a Matrix
Dear all, I have a matrix formating issue. I want to conditionally format my matirx row by row to show the monthly highest and smallest values for the years and months selected. The result sh...
Hi lbendlin! I just realized if I sort year column by other one, the code doesn't work properly.
I want to sort years inversely as you can see in the next image:
How can I solve this? I doesn't understand why doesn't run. Thank you so much.
You need to include the sort column in the formula, like you do for the month.
thank you so much!!!😁