Thanks for your help, Biff and Bryan.

Biff, your method works a treat. Bryan, I am interested in getting yours
right too, for the learning. I tried something similar to what you proposed,
but got stuck in the first condition when specifying the value. For example:

1. Formula Is: =AND(MOD(ROW(),2)=1,CellValueIs=O)

How do I write the "Cell Value Is" part, so that I don't have to specify an
actual cell (eg A10=0), but rather refers to the cell being formatted?
Sorry, could be very simple...I discovered conditional formatting about 2
hours ago!

Many thanks,
Deb

"Biff" wrote:

Yes, that does work!

Biff

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.26unrm_1146018300.9619@excelforu m-nospam.com...

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