how to write a formula for conditional formatting

[kevin lazell]

hi all
i am in need of some help with a formula peter ss has been very kindly helping with this
but he is in australia so probably still sleeping

if l3<=p1 highlight orange. both cells with dates format 00/00/0000
then the previous cell ie k3 to be no format
hope someone can help as i am desperate to get this done
thank in advance

 

[DanteAmor]

How about:

Select cells K3:L3
Formula:
=COLUMN(K3)=MAX(IF($K$3:$L$3<=$P$1,COLUMN($K$3:$L$3)))