Change event --> cell colors change

[Guest]

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!!!

 

[Peter T]

Try this -

Select cell A1
In the goto box left of input bar type A1:AK1000
Format > Conditional formats, and in the dropdown - Formula is
=AND(LEFT(CELL("format",$X1),1) = "D",$X1>0)
apply your format

If the format should only be applied if the date is correctly entered as say
1/1/2000 or later change $X1> 0 to $X1 > 36525

Regards,
Peter T