Conditional formatting and highlight every other row AND hide specific values.

[grooves12]

I have a LARGE array. I want to do a couple of things to make it easier to read. First I want to make it highlight every other row in GREY.

I found I could do this using conditional formatting using the formula=MOD(ROW(),2)=1

Second, if the cell value equals "0" I want to hide the value. So, it will need to alternate rows making all cells that match "0" white on the first row, grey on the second.

I haven't figured out how to make this work.

Any ideas?

 

[JoeMo]

Might be easier to custom format all the cells in the array so 0 doesn't show.
For example, suppose you want to have numbers in the array show to the second decimal place. Then using custom format, enter: 0.00;-0.00;
Zeros will not appear with this format.

 

[grooves12]

Thanks, that ended up being a better solution.