Identifying coloured cells

[KI]

I am using excel and i have coloured certain rows in yellow. Is there a
function or a way to quickly find or identify the rows in yellow.
For example I have 10,000 rows of data of which random 100 rows are coloured
yellow. Without having to scroll down and see where each yellow row is, is
there a way to quickly search or find the yellow rows?
Any help or advise would be much appreciated.

 

[FSt1]

hi
you can do this with the find and replace function.
on the menu bar..
Edit>find
or
keyboard shortcut Ctrl+F
on the find and replace dialog box, click the options button.
on the options screen, click the format button(top left)
on the format sceen, click the patterns tab and select your color.
click find all.
the find and replace dialog box wil display at the bottom all the cells it
found and the number it found. clicking find next will take you to each one.

regards
FSt1

 

[Andrea Jones]

If you are using Excel 2007 you can use the AutoFilter feature to filter by
colour.

Andrea Jones
www.stratatraining.co.uk

 

[Dave Peterson]

If you're using xl2003 or below, you may want to try Ron de Bruin's addin:
http://www.rondebruin.nl/easyfilter.htm