Forum Discussion
Solved
Excel Project Gantt Chart: Adding Milestone Diamond
Hello, I am trying to put a diamond shape in my excel project from: https://www.youtube.com/watch?v=tuQpGzL_14g&t=2s On 9:21. Can someone please help me why this is not working? ↓
I have received the workbook. The problem was not in the character, but in the formula.
The formula in J6 should be
=IF(J$4=$E6-WEEKDAY($E6,13)+7,"u","")
with the font set to Wingdings. Fill to the right and down. See the attached version.
Thanks! The dates in H3 to BT3 are Fridays. Is that your intention?
Could I also get some help? I'm trying to do milestones for months rather than days.
- Super helpful, thank you!
Do you know why the complete and 'on hold' formulae aren't showing up? Select K6:BJ34. K6 should be the active cell in the selection.
Enter the following formula and confirm it by pressing Ctrl+Enter to populate the entire selection:
=IF($F6-DAY($F6)+1=K$4, "u", "")- Yes, thank you! I assume that's why the other formulas I've added as 'new rules' aren't working since I'm doing months rather than days.
https://bangoroffice365-my.sharepoint.com/:x:/g/personal/mrw19rcc_bangor_ac_uk/EYngKvIqOgBOgdEf3Cxd2FsBDmMYiW75azafZl2ARYlFJQ?e=NeUWyc Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?I just saw that you PMed me. Stay tuned.