Red Flag Formula

Hi All,

Hoping to get some assistance with 2 questions. 

1. In the Child rows, I would like the flag to go red when today's date is past the finish date AND % Complete is < 100% (ie the task is past the due date and not 100% complete).

2. The flag in the parent row (Black Circle) turns red IF any of the child row flags are red below it (Red circle).

Thanks for your assistance in advance!