N
Nikki
I am trying to make a gantt chart in excel that will put a percent finished
for status. To do this I need to have excel count the number of cells that
have a certain background color. This works fine when I do not use
conditional formatting, but to make the chart user friendly I need the
conditional formatting. Is there anyway to accomplish this. ( I have two
bars one for how long the project should take and one for the current date.
I want to comapre the two bars to get a percent finished.)
for status. To do this I need to have excel count the number of cells that
have a certain background color. This works fine when I do not use
conditional formatting, but to make the chart user friendly I need the
conditional formatting. Is there anyway to accomplish this. ( I have two
bars one for how long the project should take and one for the current date.
I want to comapre the two bars to get a percent finished.)