|
(under office 2003)
ctrl h (find replace) and expand the options,then click format... on the to be replaced by cell, then the pattern tab, select the color you want to replace it with
if thats not clear enough let me know, but it's very easy to do.
opps miss read your OP, you want cells below to be colored as well... that would take a macro.
A quick and dirty would be to organize vendors by sheet, and have sheet one be an aggregate of all vendors
__________________
Donate Blood!
"Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen
Last edited by Dilbert1234567; 04-18-2007 at 08:11 AM..
Reason: Automerged Doublepost
|