charleyw78
02-15-2006, 06:46 AM
I have a very long list of numbers that have been imported from another source, each of the numbers needs to be included in another part of my spreadsheet (basically sorting everything into categories). Invariably when i get to the end i find that not all the numbers have been included, so would like a quick way to check that all the cells have been linked.
I have been trying to do something along the lines of counting dependents (there should be one for each) or conditional formatting to colour cells that don't link, but can't work it out.
I also can't work trace dependents on more than one cell at a time.
Does anyone know of a way to get this to work?
Thansk
Charlotte.
I have been trying to do something along the lines of counting dependents (there should be one for each) or conditional formatting to colour cells that don't link, but can't work it out.
I also can't work trace dependents on more than one cell at a time.
Does anyone know of a way to get this to work?
Thansk
Charlotte.