Forum Discussion
Solved
Formula for Conditional formatting of table columns
Good evening. I have a large table of 1000 rows (1-1000) and 1000 columns ("A"-"ALL") In each column there are integer values for each cell. I should highlight in Green all the columns that do not...
You hadn't told us that you're using the Italian version of Excel. Use this formula:
=CONTA.SE(A$1:A$1000; 0)=0
Hi Hans and thanks for the reply.
That's exactly what I have to do!
Highlight all columns that do not contain a 0 in green.
The formula is interpreted by Excel as incorrect, whether I select the cells from A1 to ALL1000, or whether I select them as columns from A to ALL, or whether I select only the cells of row 1.
Maybe I'm doing something wrong?
I attach the screenshots.
They are in Italian but I think you understand the meaning.
Thank you
You hadn't told us that you're using the Italian version of Excel. Use this formula:
=CONTA.SE(A$1:A$1000; 0)=0
- Hi Hans...
S-U-P-E-R!
Thank you very much!