Being a field it would be in the database. You can query for them by querying the _comprofiler table and checking your fields column. Example as follows.
Code:
SELECT c.`name`
FROM `#__comprofiler` AS c
INNER JOIN `#__users` AS u
ON u.`id` = c.`id`
WHERE c.`cb_color` = 'Red'
The above for example would select all the user rows with the color Red selected. This assumes your select fields name is cb_color and has a value of Red.
To display the results in a module I suppose you could use a 3rd party module that displays results of a database query or try using CB Content Module and substituting in a CB Query Field with your query.