Hi,

Is there a way to get excel to display a list of addresses for cells that match a particular criteria? For example, I have c1000 values ranging from +5.0 to -5.0. i want to list the cell address of values below -2. i can use conditional formatting to highlight these values, but I need to be able to extract them to a different sheet or a separate area of the same sheet.

Thanking you in anticipation,
asamani.