Help needed with Gantt chart conditional formula (working out percentage complete)
Hello! I'm new to this forum, so hopefully posting in the correct place!
I'm looking for help with Conditional Formatting. The attached Gantt chart works great for me at the moment, but I would like it to do more, namely to show progress of tasks by changing the cell colour to green as the % complete increases.
Milestone 1 takes place between 07 June and 20 Dec and is shown in red
As each underlying task is completed, the % complete changes (based on manual input in tasks under column G)
I would like cells AE5:BA5 to automatically change to green, but the rest of the row to remain red, to show that 80% of the task is complete based on the values in column G (and so on throughout the document).
Hope that makes sense! Any help much appreciated!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1