selecting formatted cells

  • Thread starter Thread starter nil jones
  • Start date Start date
N

nil jones

I have two columns of data (column A and column B). I have applied a
conditional formatting so that cells (in column B) that appear in B
but not in A are shaded. Now I am trying to select JUST these
formatted cells from column B and put them in a new file. I don't want
to have to Ctrl+Click to select them because I think there's about
5000 items that were detected as missing from Column A. Is there a way
to select and copy these cells with some function or program? note
that I am just diving into Excel and i'm learning something new
everyday. Also, I know crap for VB.

Help.

Thanks,
nil
 
Instead of using the formula in the conditional formatting dialog, put that same
formula in a helper column.

Then you can filter (data|Filter|autofilter) and filter by True/False (which
ever way you did the CF).

Then copy the visible cells to that new worksheet.
 
Back
Top