Okay, for the first 3, I'd use conditional formatting. You'll want to:
- Select F3:F302 and create a new conditional formatting rule based on a formula
- Formula: =AND($C3>0,LEN($F3)=0)
- Set the condition you want by clicking on Format (maybe a red background?)
- Select H3:J302 and create a new conditional formatting rule based on a formula
- Formula: =AND($C3>0,COUNTA($H3:$J3)<>1)
- Set the condition you want by clicking on Format (maybe a red background?)
- Select K3:K302 and create a new conditional formatting rule based on a formula
- Formula: =AND(COUNTA($H3:$J3)=1,LEN($K3)=0)
- Set the condition you want by clicking on Format (maybe a red background?)
For the last one, just use the formula (in cell L3) and copy it down: =IF(LEN(K3)>0,"Yes","No")
Bookmarks