Conditional Formating Help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help!! To modify existing formula 2
Conditional formatting with dates 7
Help ....! Conditional Formating 1
Need formula help 4
Nested IF or( If And ) can't get it to work 2
conditional formating dates, please help me 1
Conditional Formatting 2
Conditional formating problem. Please help. 7

Top