Use a CF formula of

=AND(G6="",TODAY()F6)

HTH

Bob

"housinglad" wrote in message
...
Hi

I wonder if anyone could help me, I am after code for the following.

cell e6 = Keys Sent
Column f6 = Keys due
Column g6 = Keys received

What I want the script to do is if there is no value in g6 and todays date
is greater then the date stated in F6, then the cell turns red (prompt to
inform me that keys are late).

Many thanks
Dan