Forum Discussion
gantt Excel formula Help
I am looking for a formula that can take a start date and end date to calculate percentage then add a color to the grid below the date.
Did I tell you that I am using a Mac. I am having trouble finding the same places to put the formulas.
Try looking at these links for more guidance on how to access conditional formatting on Macs. You want to select the option that allows you to use a formula :
https://support.office.com/en-us/article/use-a-formula-to-apply-conditional-formatting-in-excel-2016-for-mac-34093090-235b-4476-a7ce-1da7880c750f
https://support.office.com/en-us/article/highlight-patterns-and-trends-with-conditional-formatting-eea152f5-2a7d-4c1a-a2da-c5f893adb621