Quote:
|
Originally Posted by Dilbert1234567
(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
|
Macro, eh? /shudders
Quote:
|
Originally Posted by Shani
cant she sort the spread sheet by vendor (ie whatever column the vendor is in) the subtotal by each vendor change?
|
Of course she could. I should clarify. It's not a matter of finding the information. There are a myriad of ways for her to find the information, this is more about how she wants it formatted. It seems to be a matter of aesthetics rather than actual function.
I know...it's really, really stupid.
Thanks anyway
