Excel Conditional Formatting Based on Other Cells

I have a spreadsheet to calculate my accumulated vacation leave hours. The allotted amount is based on how many years I have been with the company. I want to highlight the row and only columns L-P in red if my balance gets close to the allotted amount. I will attach my spreadsheet, but I will also try to explain. I tried a formula like this, but it did not work. =AND($N4=$X$4,$P4<($Y$4-40)) I need the formula to be customizable based on the different amounts in the X and Y columns. Can someone help?

Please try this formula in the conditional format:

=AND($N76=$X$4,$P76>$Y$4-40,$P76<$Y$4-20)

Good luck!

Unfortunately, this did not work. Unless I am doing something wrong?

It's probably an issue with the applies to range. It must start in the same row as the row selected in the formula.
Try this range in the "Applies to" box:

=$L$76:$P$1000

Try, CF: =AND($N7=INDEX($X$2:$X$5,MATCH($N$4,$Y$2:$Y$5,0)),$P7>=$N$4-40)