Conditional Formatting Formula Assistance

Hi all,

I would appreciate some assistance with the following please:

Currently I have conditional formatting that allows a sort of Gantt Chart to be created when start and end dates are populated (columns E and G). The bit that I'm currently stuck on is for any line that has a number in column A I actually want the Gantt bar to actually be a different colour - does anyone know how I would go about this please?

My current formula is this by the way to create the Gantt in the first place:

=AND(J$2 >= $E3,J$2<=$G3)

Many thanks,
Simon