ExcelBanter - vba to filter the rows in excel by their font color

I am not quite sure i understand your question ?
do you want to solve your problem by using custom veiws in excel or do you
want to do it with VBA code.
if you do it the easy way using excel, then you can highlight each row of
one color
while holding down the Control key.when all the rows of one color are
selected,
then right click on one of the highlighted rows and select hide,this will
hide all the rows off the color you chose, "may be all the black rows"
then go to the view on the menu bar and select custom veiws click add
view,give your view a name like " No Black ".you then need to highlight all
the rows from the very top of your work sheet ,to any row that ,s below your
working range while holding down the shif key.when you have them all
highlighted right click on any highlighted row and select unhide.you then can
select the other color and do the same giveing the custom view the name " no
green".you will now have tow custom views that you can switch between by
selecting them from the view menu.. you could if you wanted start the macro
recorder before you start any of this and that would give you a macro that
you could use in any VBA code to switch any way you want... I hope this will
help you , and this is what you want to do if not just post again with more
detail and i will pist it up for you.. " remember you can do any thing you
want in VBA or Excel .. you just have to know .. what you want to do"

"cold" wrote:

hi
i have created an excel sheet, in which some rows are black and others are
green.
now i want to filter the black rows to display in my sheet.
would u pls help me?
thx

cold