Finding coloured cells

  • Thread starter Thread starter Bryn
  • Start date Start date
B

Bryn

I often receive spreadsheets where other people have marked the change
they made by colouring either text or cell, e.g. a yellow row woul
indicate a change had been made, a red row would indicate tha
something should be deleted. This is fine for small spreadsheets, bu
if I have a sheet of 20,000 rows is there a quick way to find th
marked rows?

NB: If cells in the marked rows had an alphanumeric value in
particular column, like "1" then I could use an autofilter or a sort t
get straight to these. Can anybody suggest a way to replicate thi
function but to bring back either shaded versus non-shaded cells, o
red cells but not yellow cells?

Thanks,

Bry
 
Hi
one way:
- create a helper column
- Use the UDF Colorindex from Bob Phillips/Harlan Grove which can be
found in the following thread: http://tinyurl.com/2u22g
- in your helper column add the formula =Colorindex(A1)
- copy this down

Now you can sort/filter with this helper column
 
Back
Top