Formula for Conditional formatting of table columns

ilmionomeutente 

First let's be very clear on what you mean by

I should highlight in Green all the columns that do not have any cells containing the value 0.

Do you mean, as the words seem to be saying (but I'm turning the negative into a positive) that the entire column is to be highlighted in green if every cell in that column contains an integer value other than zero.

Assuming that's the case, an easy way to do it--though not with a single formula--would be to use 1,000 helper columns, one for each of the subject/target columns, and have a formula in each cell of the helper   column to the effect, =IF(A2<>0,1,0), and then, use a total at the top or bottom of that column to serve as the basis for the conditional formatting of column A. And so forth.

If you have a current version of Excel, it's also possible that a LET function could be devised that would do all of this in a single formula, but let's hold off on that for now.