Hi All,
In my excel sheet there are 2 rows

Date In Date Out
23/05/06 24/05/06
23/05/06 25/05/06
20/05/06 24/05/06
21/05/06 27/05/06
User enters these days manually and I want to know how can I make the Date
Out format red, if Date Out is two days more than Date In. I tried to use
DateValue option but couldn't succeed.
Also is there a way to set up a reminder in excel if dateout passed by two
days?

Any help will be very much appreciated.
Thanks.