Conditional Formatting - Using Data from another column and >today()

[richtks]

Hello.

I'd like to use conditional formatting to highlight past due dates (Column 'J') based on if a "P" is present in my status (Column 'K') using a formula. Any advise?

I've tried

=and(J14:J22>TODAY(), K14:K22="P")

with no luck

 

[MountainFog]

Is that the conditional formatting formula?

What cells are you applying it to?

If applying on row 14 on, then:

=AND($J14>TODAY(),$K14="P")

 

[richtks]

Is that the conditional formatting formula?

What cells are you applying it to?

If applying on row 14 on, then:

=AND($J14>TODAY(),$K14="P")

NICE!!! Thanks!!!