Quote Originally Posted by scooooter
Thanks, that's really helpful! I just have a question which i'm unsure of how to do. How can I input the conditions? I don't know much about conditional formatting and have had a look on the net but am unsure how to tailor it into this.
Hi,

select the area that you want the condition to apply. then (note which cell is active - the odd coloured one) Format, Conditional format, and enter Formula as it would apply to the odd cell

=COUNTIF(B$8:B$24,D8)>0

(ie, D8 for that)

then set a colour pattern etc.

hth
---