Highlight cell rules based on date column

[jmjpensacola]

Hi - I am attaching a spreadsheet I am working on...I want to make it so that if any of the dates in columns I-L are less than the date in column Q, it will highlight it. I can get it to work if I am only working on that one row, but the date will be different on the different rows as they are added over time, and I don't know how to adjust the formula accordingly.

[protonLeah]

Try:
=I3<$Q3

[CARACALLA]

conditional formatting

=AND(I3<>"",I3<$Q3)

applies to =$I$3:$L$100