How to Color all my dynamic column to min max scale color?

[PeiYing15]

I would like to perform coloring in mindmidmax based on each column value. However, the column is dynamic, it is quit difficult for me to perform coloring by each column. I will end up need manual maintenance. I

<format type="color" field="column A">
<colorPalette type="minMidMax" maxColor="#53A051" minColor="#FFFFFF"></colorPalette>
<scale type="minMidMax"></scale>
</format>

<format type="color" field="column C">
<colorPalette type="minMidMax" maxColor="#53A051" minColor="#FFFFFF"></colorPalette>
<scale type="minMidMax"></scale>
</format> 

If i remove the field, it did perform the coloring for me. However, minmidmax is by whole table and not by each column

<format type="color" >
<colorPalette type="minMidMax" maxColor="#53A051" minColor="#FFFFFF"></colorPalette>
<scale type="minMidMax"></scale>
</format> 

Is there any method for me to perform minmidmax for all dynamic column i have made without manual maintenance effort.