Hi,
As I said, with 2003 you are limited to 3 conditional formats. If any of the cells can have any of the 5 conditions you can't do it with CFs, and you'd need to resort to a VBA user defined function.
If however you are prepared to have two definitions of conditional formats, one with 3 formats for the Welcome Start Goodbye cells and the other with 2 formats for the Time cells, then just use the examples in my last file e.g. using the Formula Is option, enter the 3 formats with the following,
and the two formats using the Cell value option with the greater than or equal to choice, and less than choice
HTH
Bookmarks