Thread: conditioning
View Single Post
  #7   Report Post  
DOR
 
Posts: n/a
Default conditioning

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 ...