| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditionally format cell to turn red after lookup match
I have a blank column A and a second column B with different alpha-numeric
17-characters in cells B1 to B50000. These are vehicle VINs. Now, when I enter a VIN in A1, I would like to find if this VIN is in column B and, if it is, turn the A1 cell red. Next, I would enter a new VIN in A2 and again, check to see if it is in column B and, if so, turn A2 red. I would continue this data entry down in column A for up to 700-1000 VINs. I'd expect maybe 3-4 matches after entering about 1000 VINs in column A. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format only some of the text in a cell? | Excel Worksheet Functions | |||
| how can I conditionally format a cell Part 2 | Excel Discussion (Misc queries) | |||
| How to conditionally format entire row from contents of one cell? | Excel Discussion (Misc queries) | |||
| multiple condition lookup and match cell format | Excel Worksheet Functions | |||
| Conditionally format one cell for contents of another? | Excel Worksheet Functions | |||
Threaded Mode
