Dannys Kockluss
Member
GillesD or anybody who's good at excel,
I would like to compare data like this:
1) In the range M2:BI2, find if there's any cell that has the same data value as D2. If so, make that cell BOLD, ITALIC, and make it RED WORD, BLUE BACKGROUND
2) Same thing with 1), in the range M2:BI2, find there's any cell that has the same data value as E2 (not D2), then make it BOLD, ITALIC, and make it RED WORD, BLUE BACKGROUND
3) same thing with 1), but compare the range M2:BI2 with F2 this time..
When 1) ~ 3) are done, going to next row automatically, so the range would be M3:BI3, and compare w/ D3.. then E3, then F3...
When done again, going to next row, M4:BI4, compare w/ D4, E4, F4, make the same cell format if the condtion is met....
I have to compare it up to M192:BI192, (D192, E192, F192) for this worksheet...
for the other worksheet, it's up to row300... so it would be great if i can choose "compare up to row number #?"....
is there any quick efficent way of doing it other than what i'm doing now? (Find/Replace)
thanks in advance
Dannys K.
I would like to compare data like this:
1) In the range M2:BI2, find if there's any cell that has the same data value as D2. If so, make that cell BOLD, ITALIC, and make it RED WORD, BLUE BACKGROUND
2) Same thing with 1), in the range M2:BI2, find there's any cell that has the same data value as E2 (not D2), then make it BOLD, ITALIC, and make it RED WORD, BLUE BACKGROUND
3) same thing with 1), but compare the range M2:BI2 with F2 this time..
When 1) ~ 3) are done, going to next row automatically, so the range would be M3:BI3, and compare w/ D3.. then E3, then F3...
When done again, going to next row, M4:BI4, compare w/ D4, E4, F4, make the same cell format if the condtion is met....
I have to compare it up to M192:BI192, (D192, E192, F192) for this worksheet...
for the other worksheet, it's up to row300... so it would be great if i can choose "compare up to row number #?"....
is there any quick efficent way of doing it other than what i'm doing now? (Find/Replace)
thanks in advance
Dannys K.