Conditional Formatting with 2 conditions

[Legacy 385836]

Hi

I am trying to create a conditional formatting rule based on a formula which will highlight if the cell if the due date has expired and the status column is not equal to closed. Sample data below:

Due Date Status
31/10/2017 Closed
31/11/2017 In Progress
01/01/2018 Open
31/10/2017 In Progress

In the above example, I would want to format the last date in red as the due date has past and the status has not been closed.

I have tried the following formula without any luck:

<today(),b2="<><today(),b2="<><today(),$b$2="<>=AND($A$2< TODAY ( ) ,$B$2="<>Closed")

Any help would be much appreciated.

Thanks,
Darren</today(),$b$2="<></today(),b2="<></today(),b2="<>

 

[Joe4]

Perhaps something like this:

=AND($A2 < TODAY(),$B2 <> <today(),$b2<>"Closed")

</today(),$b2<>