#1
|
|||
|
|||
Using the find function between sheets
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. |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
find function default is not saved | potolok | Word | 7 | 06-02-2014 06:44 AM |
#REF! Error in calling VBA function disappears when function is copied | lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
Find and Replace function shooting off screen to the left of the document | Mattblack | Word | 1 | 04-10-2014 03:06 PM |
Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
FIND function, where? | Yumin | Word | 2 | 04-02-2010 07:16 PM |