Return ALL rows based on a matching date also matching a specific value in another column
try this

create table #colors (
   ID       int,
   date     date,
   type     varchar(10)
)

insert into #colors values (100, '1/1/2019', 'red')
insert into #colors values (100, '1/1/2019', 'blue')  
insert into #colors values (101, '1/1/2019', 'blue')
insert into #colors values (101, '1/5/2019', 'blue')
insert into #colors values (101, '1/1/2019', 'green')
insert into #colors values (101, '1/9/2019', 'green')
insert into #colors values (102, '1/5/2019', 'blue')
insert into #colors values (102, '1/2/2019', 'green')
insert into #colors values (103, '1/1/2019', 'blue')
insert into #colors values (103, '1/9/2019', 'green')


select c.*
  from #colors c
  join #colors c1
    on c.id = c1.id
   and c1.type = 'blue'
   and c.date = c1.date
 where c.type &lt;&gt; 'blue'