Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two cells if no match
Hi,
I have about 10 thousand records. There are two columns that need to compare each rows. I need a code to run macro automaticly on Excel to check two columns for each records and set four colors in each rows based on Column A and Column B. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two cells if no match
Hi Bill,
ghvf aaaa No Match "yellow" vnmb wwww No Match "Blue" In the case of no match, how is the choice between yellow and blue to be determined? --- Regards, Norman "Bill" wrote in message ... Hi, I have about 10 thousand records. There are two columns that need to compare each rows. I need a code to run macro automaticly on Excel to check two columns for each records and set four colors in each rows based on Column A and Column B. For example: Column A Column B Comments qwer qwer Match "no colour" ghvf aaaa No Match "yellow" vnmb wwww No Match "Blue" Blank bbbb No information on Column A "light grey" mmmm blank No information on Column B "green" Your help would be much appreciated. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two cells if no match
In C1 enter (and copy down)
=IF(EXACT(B1,A1),"Match",IF(ISBLANK(A1),"No Information in Column A",IF(ISBLANK(B1),"No Information in Column B","No Match"))) Only 3 Conditional formats are required Use Cell Value is Equal to ="No Match" Add 2, and 3 HTH "Bill" wrote in message ... Hi, I have about 10 thousand records. There are two columns that need to compare each rows. I need a code to run macro automaticly on Excel to check two columns for each records and set four colors in each rows based on Column A and Column B. For example: Column A Column B Comments qwer qwer Match "no colour" ghvf aaaa No Match "yellow" vnmb wwww No Match "Blue" Blank bbbb No information on Column A "light grey" mmmm blank No information on Column B "green" Your help would be much appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
If adjacent cells both contain a match from a list, they, and 2 more adj. cells are | Excel Worksheet Functions | |||
join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
Match Dates in Two Cells and Ignore subsequent Cells | Excel Discussion (Misc queries) | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) |