Multiple IF AND OR Nested Statement

Thank you to all the Excel Ninjas out there! Appreciate your help :)

I'm trying to create a project roadmap that will color itself. Currently I am only able to get it to look at 1 set of dates, then use conditional formatting to create the color bar (gnatt chart).

Not sure if this is possible... here's my Christmas wish:

So, here's what I'm trying to do: • Look at the first set of dates, if empty, • look at the 2nd set of dates, if empty, • look at the 3rd set of dates • Determine if the dates enter falls between 2 date ranges, if so... enter 1 • I'm using the "1" and conditional formatting to color the cell (gnatt chart)

(1) First, look at N5, if empty look at L5.
If not empty, =IF(AND($J5<=AE$4,$K5>=AE$4),1,"") put a 1 if the date is in range

(2) When you look at L5 In #1, I want the following conditions:

Look at L5, if empty, look at J5. If not empty, =IF(AND($J5<=AE$4,$K5>=AE$4),1,"") same formula as above

(3) When you look at J5 in #2, I want the following conditions:

If not empty, =IF(AND($J5<=AE$4,$K5>=AE$4),1,"") same formula as above

THANK YOU SO MUCH EVERYONE! (sorry the forum will not let me post my image)