GANTT Chart - if a cell is blank, use another cell

[jrmanns]

Hello, I have a GANTT chart with 3 tasks - C)planning, D)launch, E)final. The bar chart starts at F4. Some of the projects only have planning dates, but I'd like the planning bar to be the planning date to today's date, which I have in another cell (A2).
Can anyone help me with the conditional formatting for that? At one point I had it so it had a single cell filled in for the planning date, but it wouldn't continue to today's date.

THANK YOU!!