hey guys
i'm using a table like this one :
A B C D
1 familyX | value1 | value2 | value3
2 familyY | value1 | value2 | value3
3 familyY | value1 | value2 | value3
.
.
n familyX | value1 | value2 | value3
if value1 from familyX equals value1 from familyY then highlight the two rows.
need help plz
regards
This is box of Programming, but I think your problem can be solved by conditional formatting, needn't VBA:
formula is: = Or($B2=$B1, $B2=$B3)
Last edited by ptm0412; 02-27-2009 at 11:22 AM.
Oldman Chatting: thanhmy_pham@yahoo.com Mailing: thanhmypham@gmail.com
thank you so much ptm0412
can it be done with more cells to compare ?
for example i want to highlight rows if value1 and value2 from familyY equal value1 and value2 from familyX respectively.
regards
ofcourse, mehdoush. Use this formula as condition:
=AND(OR($B2=$B1;$B2=$B3);OR($C2=$C1;$C2=$C3))
Oldman Chatting: thanhmy_pham@yahoo.com Mailing: thanhmypham@gmail.com
great ptm0412
regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks