Conditonal formatting
3 conditions

1. Cell value is equal to "0" then color 1
2. Formula is =countif($bn$3:$bn$27,$d3)>0 color 1
3. Formula is =countif($bn$3:$bn$27,$d3)=0 color 2