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

Someone will come in with a fancy formula to check for a date, but if the
cell is blank and you just want to colour the font and cell when something
is entered then select A1:F1 and go to Format<conditional formatting... set
'formula is' and enter =NOT(ISBLANK($F1))

Now when the cell contains an entry in F1 it will colour it up

You can use the format painter to copy it to other rows

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"TXNDe" wrote in
message ...

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

as Nick says it will wok you can also grey the text

=LEFT(CELL("format",F1),1)="d" as a formula in conditional formating
may also work looking for a date format

Regards

Dav


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

Just wanted to say thank you. The suggestions worked perfectly.


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