Conditional Formatting Formula

[Daviesz]

Hi there,

Can someone please help me with a formula?

I have three date columns and so far have the following formula to fill a cell red ("action required):

<today()-120,k5<today(),l5<today())
<today()-120,k5<today(),l5<today())
= AND (J5< TODAY()-120,K5< TODAY(),L5< TODAY())
J5 = "Last meeting date"
K5 = "Next meeting date"
L5 = "Next contact date"

The formula works perfectly in that the cell fills if J5 is over 120 days ago, if K5 is in the future, if L5 is in the future and does not colour if the last meeting date was over 120 days away BUT there is a future meeting or contact date set i.e. no action required, but I would also like it to fill if the last meeting was within 120 days but the "next contact date" has passed i.e. action required.

Any assistance would be greatly appreciated.

Thanks,

Karl</today()-120,k5<today(),l5<today())
</today()-120,k5<today(),l5<today())

 

[Daviesz]

Sorry, that should have been "The formula works perfectly in that the cell fills if J5 is over 120 days ago, if K5 is not in the future, if L5 is not in the future