Filter by cell color

[Guest]

Is there a way to filter by cell color?
Thanks,
Duncan_J

 

[Frank Kabel]

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

 

[KL]

there may be another way:

1. Go here http://www.jkp-ads.com/Download.htm#arg2name and download
http://www.oaltd.co.uk/DLCount/DLCount.asp?file=Arg2Name.zip

2. Open the file and see how the CellColor named formula works.

3. Setup the CellColor named formula in your worksheet, create an additional
column in your table and fill it with the formula.

4. Use autofilter in the created column

Note: since changing cell color doesn't trigger recalculation, you may need
to force recalculation in some way. In that sense Chip Pearson's solution
has a clear advantage.

Regards,
KL

 

[Bob Phillips]

Note: since changing cell color doesn't trigger recalculation, you may need
to force recalculation in some way. In that sense Chip Pearson's solution
has a clear advantage.

Filter doesn't get regenerated if a recalculation takes place anyway!

 

[KL]

Sorry, I should have said "...you may need to force recalculation in some
way BEFORE FILTERING..." But I guess this is irrelevant for the purposes of
comparing the two solutions as it applies in both cases.

KL

 

[Bob Phillips]

Exactly, my point was that this is not a constraint.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks guys,
But a simplier fix I thought of is to filter the reason they're are colored
to begin with... Then use visible cell only and rename them sale-r(for red)
and sale-g (for green) Then when they loose thier color thanks to the vlookup
I can just do a find and add the colors...
Thanks
Duncan_J