ranuse
02-25-2011, 10:48 AM
Hi,
I'm having trouble implementing a macro that will look at sheet1 column A as source/reference column and replace the formatting (cell fill color) of sheet2 column B depending on which values are in A.
For example,
Sheet1 Column A (a subset of Sheet2 Column B) contains:
1
3
4
5
12
7
Sheet2 Column B contains:
0
1
2
11
3
4
5
20
12
7
I want to do a find value on Sheet1 Column A and replace formatting of the same value located in Sheet2 Column B.
Any help is appreciated.
Thanks.
I'm having trouble implementing a macro that will look at sheet1 column A as source/reference column and replace the formatting (cell fill color) of sheet2 column B depending on which values are in A.
For example,
Sheet1 Column A (a subset of Sheet2 Column B) contains:
1
3
4
5
12
7
Sheet2 Column B contains:
0
1
2
11
3
4
5
20
12
7
I want to do a find value on Sheet1 Column A and replace formatting of the same value located in Sheet2 Column B.
Any help is appreciated.
Thanks.