Forum Discussion
Formula for Conditional formatting of table columns
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
Select A1:ALL1000. A1 should be the active cell in the selection.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=COUNTIF(A$1:A$1000, 0)=0
Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.
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!
- much better than what I said!
