See http://www.sulprobil.com/html/vacation_plan.html

(use at your own risk)

It's an example which looks at 2 cells and you can copy the conditional
format into other rows.

HTH,
Bernd