Automatically highlight the next incomplete row?

Perhaps you should look into Conditional Formatting? Set a rule that highlights blank cells?

Select your data range, click Conditional Formatting under the Home tab (sorry I'm on Windows, I assume this is similar on Mac), New Rule, Format cells that contain-->Blanks

Originally Posted by bmouse

Perhaps you should look into Conditional Formatting? Set a rule that highlights blank cells?

Select your data range, click Conditional Formatting under the Home tab (sorry I'm on Windows, I assume this is similar on Mac), New Rule, Format cells that contain-->Blanks

Thank you, I think you might be onto something with conditional formatting.

So far I've successfully used it to highlight all empty "date paid" cells but really what I want is for the whole row to be highlighted in this way but because the other cells aren't blank it won't work, any ideas?

Try fiddling with the rules. Set to highlight the entire row under this rule =COUNTBLANK($D$1)>=1

D1 is your target cell. When you enter any value in D1, the row will then be un-colored.

Try this rule:
=IF(ROW()-COUNTA($A:$A)=1,1)