mass conditional formatting columns, with out manually formatting each column

[joro613]

Using the built-in heat map styles, is there a way to apply mass conditional formatting with out manually formatting each column? For example, in attached file example I want to see each column in a unique heat map? For example I had to manually apply the format to each column, and would love to apply the heat map, to heat map color code each column uniquely, but many columns at the same time.

Heat Map Example

 

[Fluff]

Hi & welcome to MrExcel.
Unfortunately they will need to be applied to each column individually.