Try 3 conditions,

first = AND( row , values) -- shading and red font
second = rows -- shading
third = values -- red font

Hope this helps

--

Smurfette Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=536233