It's not really all that important, but a working solution would score me some major points with the boss.
She has this huge balance sheet. The usual stuff, names of vendors, acquisition numbers, invoice numbers, amount paid and running total deducted from the starting budget off to the far right. Nothing too complicated.
What she would like is a way to color code the whole row by (I assume) vendor name (e.g. orders from Alibris would be colored light green, etc. etc.). She would also like every subsequent entry of Alibris in the future to automatically highlight light green. In addition (I know, she doesn't ask much does she?) she'd also like to be able to tally up by vendor (e.g. totalling all purchases made solely from Alibris over the past year).
Now, I'm moderately well versed in Excel and I can sort of do this using conditional formatting. I can highlight all Alibris entries including the matching entries as they are being entered into the spreadsheet. However, it doesn't highlight the entire row and it's a bit cumbersome. In addition, I have no idea how to do the last bit....at all.
I've been beating my head against the computer on this for a couple of hours now and I guess, I'm starting to crack.
Help me TFP, you're my only hope. /leia