conditional formatting/data validation?

Hi Guys,

Okay so i have 2 columns, Date Sent & Date Received.

I want to make it so that the Date received cannot be entered unless the date sent has been filled out. I am wanting to create a msgbox prompting the user to enter Date Sent if they try to enter any data into the Date Received cell without having anything in Date Sent.

VBA code is not my strong suite, is there a way to do this with functions or will this have to be done in VBA?

if you put a data validation of formula
>cell date sent
then it can provide an error message
you can also had a note - so that a message appears when you click on the cell

Ie - Is there a Sent Date ?

using the normal validation

Data > data validation

so if the cells where D4 and E4
formula =
=E4>D4

see attached

Hi this didn't make sense.. I'm trying to make it so there must be a date entered into the date sent cell e.g b2 before you can enter date recieved into c3.