Filter columns by fill colour

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

Ascesis wrote:
> 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.
>
>
> --
> Ascesis
>
>
> ------------------------------------------------------------------------
> Ascesis's Profile: http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=567487

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

--
HTH

Bob Phillips

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

"Ascesis" <Ascesis.2bx4zf_1154532013.6322@excelforum-nospam.com> wrote in
message news:Ascesis.2bx4zf_1154532013.6322@excelforum-nospam.com...
>
> 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.
>
>
> --
> Ascesis
>
>
> ------------------------------------------------------------------------
> Ascesis's Profile:
http://www.excelforum.com/member.php...o&userid=36801
> View this thread: http://www.excelforum.com/showthread...hreadid=567487
>

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.


Ascesis wrote:
> 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.
>
>