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.

What if the number occurs on more than one sheet? Besides which, the job could be done via conditional formatting, without the need for code. the conditional format formula for 'red' would be:
=(MATCH(A1,Red!A:A,0))<>"N/A"

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]