Conditional Formating Help

  • Thread starter Thread starter housinglad
  • Start date Start date
H

housinglad

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
 
Back
Top