Hi E,

Try using Excel's Conditional Formatting feature (Format | Conditional
Formatting...).

If you are not familiar with this feature, see Debra Dalgleish's tutorial
at:

http://www.contextures.com/xlCondFormat01.html

If you need to automate this, turn on the macro recorder and perform the
required steps manually. This will provide you with base code which may be
edited to enable more general application.

If you experience difficulties with such editing, post back with the
problematic code.


---
Regards,
Norman



"EW" wrote in message
...
All-
I want to integrate some code to make a cell to fill green when on-time is
scheduled and fill red if it is not scheduled.

Thanks in advance!