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