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