Thanks for your reply. I took a look at my data, and there is the
possibility of having two blank rows between the data. Never more than two
though. How do I alter your formula to reflect this?

Also, if I was to use your formula, do I insert it as a separate condition?
Or can I tack it on the end of my primary condition somehow?

Regards,
Casa

"Dave" wrote:

Hi,
If there is never more than one blank row between rows of data, (ie, no
consecutive blank rows) try:
=If(ISBLANK($B3),$C2<$B4,$C2<$B3)
Regards - Dave.