Font Color Change based on 3 criterias

Hi everyone, i hope somebody can help.

I want to change the font color in one cell based on the criteria of 3 cells. For example, my cell range is from D1:G10

I want to change the font color for:

cell G1 to Grey if D1, E1 and F1 = "not applicable"
cell G2 to Red if D2, E2 and F2 = "No"
cell G3 to Green if D3, E3 and F3 = "Yes"
cell G4 to Orange if D4 = "Yes", E4 = "Yes" and F4 = "No"
cell G5 to Orange if D5 = "Yes", E4 = "not applicable" and F4 = "No"

and so on and so forth.

Please help me, i'm really having difficulty. Thanks