The closest solution I found is below macro script (it applies horizontally, what I need is a vertical one)
Can someone help me? Thank you
Currently, I did that manually go to one by one column and apply the color scale.
And from this link https://webapps.stackexchange.com/a/123048/257611, it was able to do an automatic color scale to each row, not column. It goes like this (i change the date to row):
I need a way to execute color scaling in a column format to run vertically without doing it manually like picture 1.