Change event -- cell colors change
 

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

Change event -- cell colors change
 

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",$X10)
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

"Mr. Dan" wrote in message
...
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!!!