Hi there,

I've applied Formula is =MOD(ROW(),2)=1 and selected a shading colour for my
table. However, if the cell values = 0, I want the numbers to be red.

Can't seem to get it to work, as when both conditions are true, the second
one gets ignored. Perhaps it's to do with OR/ AND statements?

Help appreciated!

Thanks,
Debbie