Colored Harvey Balls

[bmontoni]

Hi Everyone,

I am wondering if it is possible in excel to create a formula that will return a gray ball if a task is not started (status = Not Started AND TODAY is greater than End Date), a red ball if the task is past due (status = anything other than Completed), a green harvey ball if the task is on track (Status = In Progress; AND TODAY is greater than End Date + 3 days), a yellow ball if the task is at risk (Status = anthing other than Completed; AND TODAY is less than or equal to End Date + 3 days), and a blue ball if the task is completed.

Thanks in advance!!

 

[dave3009]

Did you accidentally snip off part of your homework question? Only part of it's visible.

 

[bmontoni]

Did you accidentally snip off part of your homework question? Only part of it's visible.

Not sure how that second screenshot got it there - it can be disregrared.