Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Conditional Formatting
I have two columns of numbers. One small set (25-200, imported daily) of
numbers in column B, and 8365 unique numbers in column K. I would like to use conditional formatting to tell me if any of the numbers imported into column B match any of the 8365 unique numbers in column K. If so, I would like the numbers in column B that match to turn Red. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Conditional Formatting
HANK,
Use CF with the Formula Is option, with a formula like =NOT(ISERROR(MATCH(B2,K:K,False))) where B2 is the activecell at the time that you apply the formatting. And if the empty cells are turning red and your want to prevent that.... =AND(B2<"",NOT(ISERROR(MATCH(B2,K:K,False)))) HTH, Bernie MS Excel MVP "HANK" wrote in message ... I have two columns of numbers. One small set (25-200, imported daily) of numbers in column B, and 8365 unique numbers in column K. I would like to use conditional formatting to tell me if any of the numbers imported into column B match any of the 8365 unique numbers in column K. If so, I would like the numbers in column B that match to turn Red. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Conditional Formatting
Try this...
Select the range of cells. Assume this range is B2:B201 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MATCH(B2,K$2:K$8366,0) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "HANK" wrote in message ... I have two columns of numbers. One small set (25-200, imported daily) of numbers in column B, and 8365 unique numbers in column K. I would like to use conditional formatting to tell me if any of the numbers imported into column B match any of the 8365 unique numbers in column K. If so, I would like the numbers in column B that match to turn Red. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL Conditional Formatting
One way
Select col B (B1 active), apply CF using Formula Is: =COUNTIF($K:$K,B1) Format to taste ok out Yes? Pl click the YES button below -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "HANK" wrote: I have two columns of numbers. One small set (25-200, imported daily) of numbers in column B, and 8365 unique numbers in column K. I would like to use conditional formatting to tell me if any of the numbers imported into column B match any of the 8365 unique numbers in column K. If so, I would like the numbers in column B that match to turn Red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: Conditional Formatting | New Users to Excel | |||
Excel Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel | Excel Worksheet Functions | |||
Excel and Conditional formatting | Excel Discussion (Misc queries) | |||
Excel 07 Conditional Formatting Help! | Excel Worksheet Functions |