Need Formula for Automating RYGG Balls

I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are.

If end date is prior to TODAY, = Red

If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow

If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green

If End Date is Blank = Gray

I keep messing my IF formulas up and it isn't working.

Help?

Find more posts tagged with

Formulas

Hi Tera..did you figure it out?

I haven't... here is the link. Project health column is the one i need the formula for that references today's date and start and end date columns.

Publish the sheet to the web and gives us a look.