Conditional Formatting in Excel [Closed]

Report
Posts
1
Registration date
Thursday May 30, 2013
Status
Member
Last seen
May 30, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have built a GANTT chart using Excel, and have been able to create the formulae in the task bar cells that allows the proper display of those bars in the chart body - with the correct start date and end date for each task.
What I now want to do is employ "conditional formatting in a cell based upon content in another cell". The chart has a column - the cells in which contain an arbitrary "task completion percentage" and I want the cells in each task bar to reflect a different color based upon task completion (i.e. 100% - dark green; 75%-99% = light green; 25% - 74% = orange; 0% - 24% = red).
What I want to do is have each task bar cell read the appropriate completion column cell and apply the appropriate color - but I cannot figure out how to append the cell coloring formula onto the existing formula in each task bar cell.
Any suggestions (or hopefully .. solutions) will be greatly appreciated.
Mike

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
A sample book would help in looking into issue. You can post a sample book at some public file share site and post back the link to the file back here

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!