I've set up a rather simple looking (feel free to suggest or change anything)

http://www.sendspace.com/file/ohks06

As you can see its very simple! i Just want to add Column E a formula to say if certain number in Column D is met then the Cells in E will say yes or no.

Then in condtional formatting i want to highligh all rows when YES is met

p.s. any tinkering to make it visually better are welcome

thanks all

Paul