Filter columns by fill colour

[Ascesis]

How do I filter columns by the colour the cells have been filled with?

I've tried all kinds of hexadecimal junk with the advanced filter, with
no luck.



Your help will be appreciated.

 

[Pete_UK]

You could use a helper column to hold a code representing the colour,
eg R for Red, O for Orange, Y for Yellow etc. and filter on this
column. Chip Pearson has a lot of stuff about dealing with colours
here:

http://www.cpearson.com/excel/colors.htm

Hope this helps.

Pete

 

[Bob Phillips]

See http://www.rondebruin.nl/easyfilter.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[m96]

actually i'm using something like:


currentColor = activecell.interior.colorindex

for each c in usedrange.columns(activecell.column).cells
if cell.interior.colorindex = currentColor then
c.entirerow.hidden = false
else
c.entirerow.hidden = true
end if
next c

and if you still want to show the first row (e.g. column header) then

range("A1").entirerow.hidden = false


hope this helps.

cheers.