THANKS A BUNCH. THIS FORMULA WORKED PERFECT. YOU ARE A LIFE SAVER.

"DOR" wrote:

Use the following conditions:

=G3F3 --red
=G3=F3) --yellow
=AND(G3<"",G3<F3) --green

You might also use data validation on the date fields to ensure that
only dates are entered in them ...