Use the same formula in another column and then use Data Filters to show
only TRUE values. But you will need to use Ctrl-Shift-Enter instead of just
enter when you use that formula in a cell.

HTH,
Bernie
MS Excel MVP


"calibansfolly" wrote in message
oups.com...
This works. Is there a way then to sort these, or delete or hide the
rows that aren't red?