Have a look at conditional formatting before you decide on a code solution:
http://www.contextures.com/xlCondFormat01.html

HTH. Best wishes Harald

skrev i melding
ups.com...
Hi all,

can someone help me find code for highlighting 3 conditions - entire
row interior grey - and 1 when a date is passed to highlight the font
bold red, entire row again?

Also, I need to set a reminder to appear on the first day of every
month when the workbook starts up.

Any help appreciated! :)

Doo