On The Insider: Oprah's Next Project on HBO
BNET Business Network:
BNET
TechRepublic
ZDNet
TalkBack 1 of 2:
Next »
A couple of ways to do it...
Since he doesn't actually state how the data gets into the columns (VLOOKUP? Macro?) there's no way to say what's the best way to do it. If there's another column that indicates which data source it came from, his best bet is to use Conditional Formating. Otherwise, he will probably need to write a macro to loop through the data, find out which source it came from, then color code the cell.

J.Ja
Posted by: Justin James   Posted on: 01/05/06 You are currently: a Guest | Members login | Terms of Use

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

A couple of ways to do it...  Justin James | 01/05/06
Excel newsgroups  TimC_z | 01/05/06

What do you think?

SponsoredWhite Papers, Webcasts, and Downloads

SmartPlanet

Click Here