I work in Learning Support, and a lot of my students like to have a coloured
background on worksheets, to alleviate tracking difficulties when reading the
text etc... However, although anything other than white is better (e.g. cream
/ off white)they tend to have their own personal colour which is best for
them.

What I'd like to be able to do is to quickly change the colour of cells to
suit their individual preferences. However, I often use other colours within
my worksheets to indicate "notes" cells, table headers, input cells, output
cells, etc... etc... If I select the whole sheet to colour, so that every
cell gets a new interior (fill) colour, this obviously affects those cells
that I want to stay the same as well. So I then have to re-select the 30-odd
input cells, colour those back to their original colour, then the output
cells etc...

This can take far too long to make it worthwhile. Is there a way to select
all of just one particular type of cell (e.g. all the "background" cells) and
not the other coloured cells that I want to stay the same? I've tried naming
the input cells etc... and using "Go To", but it would seem that it can only
refer to a certain number of different ranges, and if the cells are spread
non-adjacently through the sheet, one name is not enough to capture all of
them.

Ideally I'd like a macro or similar so that I can specify which interior
colour index to pick out, and select all of the cells in the worksheet that
meet that criteria, so that I can then format those cells only, leaving the
others untouched. Is there some sort of code to do this?

Even better, does anybody know of a way such that on pressing a button, say,
a dialog box could pop up to ask me what interior colour to look for (which I
would enter), then ask me what colour I want to change these cells to (which
I would enter again), and then select them all and make the change for me?

If this was possible, I could really do a good job in differentiating for
the students without it taking me forever to do so. Any help would be really
appreciated.

Many thanks in advance, Neil