Got a cell, need to colour this a particular colour providing that in a series of cells elsewhere there's at least one entry that matches a particular value.

Looking at the conditional formatting option i can only colour this particular cell by getting it to look at the value contained within itself

is there anyway around this? hope i made enough sense!