Using color scale conditional formatting on columns

Hi,

I'm trying to use use color scale conditional formatting of green to red on multiple columns, but I'd like to get the green to red range to be on each column separately and not on the whole range.
I know I can use the format painter to each column separately, but when doing that on more than 500 columns, it still takes time...
An example is in the attached sheet.

I appreciate your help.


Thank you,

Moty