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

it would be easier with your file uploaded to see what you have done, but do try:

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

as a second CF formula...

or...

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Almost worked = didn't work. try this.

=AND(J$2 >= $E3,J$2<=$G3,ISNUMBER($A3)) and put that CF ABOVE the one doing the other colour and below the weekend one. thanks for the Rep, BtW.