Conditional formatting

[JHelmore]

I have 2 sets of dates, depart and return dates I would like both cells to change colour when both dates are in the future.
So the depart date may have past but the return date is still in the future so would like both cell filled in until both dates have past.

Hope this makes sense

 

[Joe4]

Welcome to the Board!

Let's say that those two dates are in cells A1 and B1.
Then select both, and go to Conditional Formatting, choose the Formula option, and enter this formula:

=AND($A1>TODAY(),$B1>TODAY())

and choose your formatting color option

 

[JHelmore]

Hi Joe4

Many thanks for your reply
your formula this works if both dates are in the future but if the depart date has past but the return hasn't it doesn't work

Jackie

 

[DanteAmor]

Try:

=$B1>TODAY()

Applies to:
=$A$1:$B$1

 

[tyija1995]

I have 2 sets of dates, depart and return dates I would like both cells to change colour when both dates are in the future.

Joe's solution provides exactly this, what are you expecting to see if:
A) Departure date is in the past & return date is in the future
B) Both dates are in the past

 

[Joe4]

Yes, this is what I programmed to:

I have 2 sets of dates, depart and return dates I would like both cells to change colour when both dates are in the future.

If you want BOTH to be highlighted if just column B is in the future (so it doesn't matter what is in column A), then use DanteAmor's formula.

 

[JHelmore]

thanks DanteAmore works perfect thank you

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.