Hello -

I have the following scenario and need the formulas:

If D37 is "Yes" then D40:D42 = "N/A"
If D37 is "N/A" then D38:D39 = "N/A"
If D37 is blank then D38:D42 are blank

I already have one condition for D37 - if it's zero, then turn the cell
green. I only have two conditions left.

Is there a way this can be done?
--
Sandy