Hey Guys,
I need help to do below in excel. I want to check value of each cell in Column C againt whole of column A and color any cell in Column A which has a match.
below example 111 (both), and 123 in column A should be colored. pls help. Thanks.
Column A Column B Column C
111 A 145
123 B 111
134 C 123
111 D 100
Last edited by ashieshk; 04-14-2014 at 11:43 PM.
If you have values in col. A in the range A1:A10, select B1:B10, while B1 is still the active cell, make a New Rule for condition formatting and place the formula given below in the formula box and format as per your choice.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Thanks sktneer for quick reply..
And sorry for being dumbI am not an excel pro i am thnk I am not doing something right as I tried what u said.
for my excel sheet
Column C in example maps to Range U2:U1618
Column A in example maps to Range B2: B32991
Thanks fr your help..
Then the formula will be changed to ........
Select the range U2:U1618 --> Conditional Formatting --> Make a New Rule --> in the formula box place the above formula and format as per your choice.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks