Is there a way to create a macro that will highlight a range, fill it
with color and change the font color upon entering a date into a
specific cell?
Example below shows how I have my headings. I want to create a macro
that once I type a date in cell "F1" (date closed) that it will
highlight range "A1-F1" fill in the range with a light yellow and gray
the text.

Company Fname Lname Date Recvd Date Due Date Closed

Any help would be greatly appreciated.

Thank you.


--
TXNDe
------------------------------------------------------------------------
TXNDe's Profile: http://www.excelforum.com/member.php...o&userid=36253
View this thread: http://www.excelforum.com/showthread...hreadid=560457