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!