Hi,

I have a spreadsheet with 1000+ rows. Column X contains a blank field that
represents a complete date. When the user enters in a complete date
(xx/xx/xx), I would like the row from column A through column AK to change to
a different color. The complete dates may be entered into any row anywhere
on the spreadsheet.

I know I can use conditional formatting, but with so many rows I can't
possibly format each row individually. Can anyone provide a VB-based
solution?

Thanks!!!