I am happy to google 'how to' once I know what to google!
I would like to enter in a list of secondary schools and the scores that are needed for entry into those schools. I then want to enter in a list of children with their scores and have excel return a list of schools for each child: a specific number of 'stretch' schools, a specific number of 'comfortable' schools and a specific number of 'back up' schools. I would like this list to be conditionally formatted for each child so that their stretch schools are coloured yellow and their back ups are coloured light purple.
So far I have three sheets: one with the schools and the entry scores; one with the pupils names and their scores (and the number of each type of school I want returned); and one with the output.
I have instructed Excel to copy the names from the INPUT sheet and put them in the OUTPUT sheet, but that's the only thing I know how to do. I know how to use vlookup and also how to conditionally format cells.
Please could someone tell me which formulae I need to use. Again, I'm happy to do the googling to find out how to use them.
(I think I've attached a screenshot of the INPUT sheet.)
Many thanks.
Bookmarks