Hi All,
I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome.
10 days or more before todays date = green
10 to 6 days before todays date = amber
5 days or less before todays date = red
100% complete = blue.
I hope I have explained this correctly and it is not unusual request as this formula may have been provided previously.
Any help will be gratefully received.
Many thanks
I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome.
10 days or more before todays date = green
10 to 6 days before todays date = amber
5 days or less before todays date = red
100% complete = blue.
I hope I have explained this correctly and it is not unusual request as this formula may have been provided previously.
Any help will be gratefully received.
Many thanks