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
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.
much better than what I said!