It really seems that formula should work, but it just doesn't. No quotes. I
can make it work in other spreadsheets, but not this one. I think my
condition 1 for alternating 3 shaded rows may be over riding condition 2
somehow.

"Dav" wrote:


Try entering the following in conditional formating as a formula in cell
d2
=C2<D2 and choose the colour red

It can then be pasted down with paste special as a format to all the
other cells.

If it does not work in the first cell check excel has not enclosed it
in quotes

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=538457