Yes if you have another formula it will override it as it stops at the
first condition that is satisifed

Try using c2<d2 as your first condition and the shading as your second
condition, this should work, otherwise it will just shade. You never
meantioned any other conditional formats before!

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