Hi,
I have a workbook that tracks pieces of equipment, part of the data is the serial number of each piece of equipment.
One of the sheets in the workbook is a compiled list of all the serial numbers of the equipment we think we have.
What I want is some way of highlighting to someone who is filling in data about these bits of equipment, that a serial number they have just input is not on the compiled list.
If I use the data validation 'list' option that stops people inputting a serial number that isn't on the compiled list. I still want them to be able to input the 'wrong' serial number, just have the cell highlighted, or a formula in an adjacent cell which then shows a 'correct' or 'incorrect' serial number message.
What's a neat and tidy way of doing this?
I have a workbook that tracks pieces of equipment, part of the data is the serial number of each piece of equipment.
One of the sheets in the workbook is a compiled list of all the serial numbers of the equipment we think we have.
What I want is some way of highlighting to someone who is filling in data about these bits of equipment, that a serial number they have just input is not on the compiled list.
If I use the data validation 'list' option that stops people inputting a serial number that isn't on the compiled list. I still want them to be able to input the 'wrong' serial number, just have the cell highlighted, or a formula in an adjacent cell which then shows a 'correct' or 'incorrect' serial number message.
What's a neat and tidy way of doing this?