the only thing i managed to do was =NOT(ISBLANK(C101:C104)) and set it to orange using the conditional formatting.
I would like to have green if everything or everything but
D:D is filled out, orange as soon as C is given and red as soon as C is missing. Any ideas how to do this? I tried:
as a conditional formatting formula for green but that didn't work.
yellow should be:
still I don't know which rule is applied first.