The spread sheet has so many cells and takes ages to go through and then make
a note of the ones that are coloured is it possible to getthe different
coloured displayed on a seperate spreadsheet with the location that they come
from or is that too complicated.

"Bob Phillips" wrote:

What do you mean exactly by displayed?

--
HTH

Bob Phillips

(replace somewhere in email address with googlemail if mailing direct)

"fomula problems" wrote in
message ...
I have a spreadsheet and certain cells are coloured to represent certain
criterier, I would like to display all of one coloured cells to show
status
of that colour, say I want all the red cells locations to be displayed so
that i can check the status.
Alan