each clause in the IF is taken separately - as soon as one is true then the total condition is satisfied and the next record is processed
Can't see your data so this will get you close
IF ([A] = "Y") and [B}='Y' and [c] ='Y" THEN "Green"
elseIF ([A] = "N") and [B}='N' and [c] ='N" Then Red
else "yellow" end
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.