# Gantt Chart Formula Problem

1. ## Gantt Chart Formula Problem

Hello,

I am trying to write a formula for a Gantt chart in excel where the timeline is in months. I want the cells to return a 1 or a 0 so I can use conditional formatting g to complete the bars on the Gantt.

I have written the formula I think should work, but it is not returning the write numbers in the cell.

Is there anyone who may be able to help with this? I attach the spreadsheet with the formula in it.

Many thanks,

2. ## Re: Gantt Chart Formula Problem

1) The initial formula would be:

=MEDIAN(\$B3:\$C3,E\$2)=E\$2

or even better:

=AND(COUNT(\$B3:\$C3)=2,MEDIAN(\$B3:\$C3,E\$2)=E\$2)

2) You don't put this in the cell, you highlight all the cells you want to apply this to starting with E3, the simply create the CF rule using that formula above and the color of choice.

3. ## Re: Gantt Chart Formula Problem

Thanks so much for your help!! Much appreciated.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1