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,
Adam
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks so much for your help!! Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks