Excel 2007 : Conditional Formatting - Highlighting Entire Rows based on a between function

Ladies and Gentlemen,

I have a bit of a problem with conditional formatting. I've looked around for quite a bit and haven't found a solution.

I would like to highlight entire rows based on the values in column C. This is fairly straight forward for greater than, less than, or equal functions. How would I go about achieving this for a between function?

08:00:00 > x < 16:00:00

I am evaluating a time sheet which is linked to our electronic entry system and need to highlight employees entering after the beginning of the work day or leaving before the end of the work day.

Regards,


Steven