Hi,

I have 4 sheets in my workbook(list, red, green, blue), in the first i have a list of numbers.

I want to go through each number in 'list' and check if it is in 'red', 'green' or 'blue' and then turn the background colour of that number either, red, green or blue.

I've been trying with .Find but ive become quite stuck.

Any help is much appreciated.