Conditional Formatting - Not blank, Date older than 15 days, Adjacent cell blank

[pdaughe1]

Please help... looking for a solution where the cell in column K is not blank, the date is older than 15 days AND the adjacent cell is blank. I have a formula that works for the first two requirements but not if the adjacent cell is blank.

=IF(ISBLANK($K1),0,$K1<TODAY()-15)

 

[SanjayGMusafir]

Check this and revert - Assuming adjacent cell is Column J

=And($K1<>"",$K1<Today()-15,$J1="")

 

[pdaughe1]

Perfect... thank you! It works!

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.