Filter of rows based on color in excel

[MAliShah]

Hi All
How i can filter the excel sheet for rows based on color?

 

[xlbo]

You can't
The only way to do this would be to have a UDF that extracts the colours and represents them with a number or other hard data


Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[Loomah]

Hi
I think you'll need to give more detail than you have here. Colour of what? Do you want rows that contain a certain colour? If so what generates the colour?

The other thing here is I think you'll be looking at a code solution so I would recommend reposting to the VBA forum : forum707. A lot of contributors frequent both forums but probably not all!

;-)

If a man says something and there are no women there to hear him, is he still wrong?

 

[koresnordic]

If you mean that the user highlights a row and then wants to only show the rows highlighted. Then the way I would do it is to have another column call "check". The user puts a mark in this field. Then have an autoformat based on this field that if not blank, turns the row a different colour (or whatever format you have setup). Then since there is a column that has sortable data, sort on the "check" column and you will only see the selected rows. This works and the user doesn't have to highlight a row and change the format.



Graham