Formula Help with Attached Spreadsheet Needed -Many Thanks in Advance

Good afternoon,

I'm trying to get column k of the attached spreadsheet to populate based on some conditions. I'd like each column row in column k to either be Green, Amber or Red, but based the criteria from column e and column h.

BTW, today's date is listed in L1.

For example, if H4 is less than today's date and e4 is "in-progress" i'd like k4 to say, "Green".
If E4 is marked "completed" would like k4 to say "Green"
If H4 within 3 days of today's date and "in-progress" would like k4 to say "amber"
If E4 is marked "Risk", and before = h4 date, would like k4 to say "amber"
If H4 passes today's date, would like k4 to say "red"
If H4 is marked "Late" would like k4 to say "red"

Appreciate the help. Thank you =)

Please see attached test sheet.

Do you want text or colors? (If colors then us Conditional formatting (but that can get touchy)
I assume H - will always be a date and E will be Completed,In Progress, Risk and Late

You can do a nested IF statement : If(Condition,True,If(Condition,True,If(Condition,True,False)))
Nail down the conditions
E "Completed" THEN Green
H>Today() THEN "Red"
E "In Process" AND H-Today<3 THEN Amber
E "In Process" THEN Green
E "Risk" THEN "Amber"

The Statements are evaluated in order As soon as True is found - the formula is done