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
768
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