Hello,
I am using an Excel table to track action items decided in meetings. For instance, I will have an action like "Paul needs to talk to Roger" in A1, then in B1, I have the date this is supposed to happen, say "3/1/2017", and in C1 I have used conditional formatting/gradient fill to track the progress of the task, say "50%". Till here, no problem. Now, the gradient is only one color. What I would like to do is that if the progress is 50% for instance or anything different than 100%, and the date where the task is supposed to be completed has not passed, I would like the gradient to appear in green (this will tell me that this task is not late). If the date has passed, I would like the gradient to be in red.
Thanks in advance for your help with that
Pascal
I am using an Excel table to track action items decided in meetings. For instance, I will have an action like "Paul needs to talk to Roger" in A1, then in B1, I have the date this is supposed to happen, say "3/1/2017", and in C1 I have used conditional formatting/gradient fill to track the progress of the task, say "50%". Till here, no problem. Now, the gradient is only one color. What I would like to do is that if the progress is 50% for instance or anything different than 100%, and the date where the task is supposed to be completed has not passed, I would like the gradient to appear in green (this will tell me that this task is not late). If the date has passed, I would like the gradient to be in red.
Thanks in advance for your help with that
Pascal