Filter by cell color
 

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

Filter by cell color
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


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

Filter by cell color
 

there may be another way:

1. Go here http://www.jkp-ads.com/Download.htm#arg2name and download
http://www.oaltd.co.uk/DLCount/DLCou...e=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

"Duncan_J" wrote in message
...
Is there a way to filter by cell color?
Thanks,
Duncan_J

Filter by cell color
 

"KL" wrote in message
...

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!

Filter by cell color
 

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" wrote in message
...

"KL" wrote in message
...

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!

Filter by cell color
 

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

--

HTH

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


"KL" wrote in message
...
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" wrote in message
...

"KL" wrote in message
...

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!

Filter by cell color
 

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

"Bob Phillips" wrote:

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

--

HTH

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


"KL" wrote in message
...
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" wrote in message
...

"KL" wrote in message
...

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!