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

[stevenblanc]

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

[NBVC]

Try using formula:

=AND($C2>TIME(8,0,0),$C2<TIME(16,0,0))

where C2 is in topmost row of your selected rows to format.

or

=AND($C2>=TIME(8,0,0),$C2<=TIME(16,0,0)) if you want to include the range limits.

[stevenblanc]

Marvelous. Simple solutions always seem to be the most slippery.

It works like a charm.

Many thanks,


Steven