You could use functions like VLOOKUP and SUMIF. It depends on your data layout.

To color cells, use conditional formatting.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Barbara" wrote:

I am trying to automate a large task. I would like to be able to enter a
Task Number into a cell and have several things happen: I would like the
description, the unit of measurement and the unit price automatically
entered. In this same spreadsheet, I would like to be able to carryover from
the prior months worksheet the amount of money already expended to a category
and I would like it it let me know when we are getting close the the maximum
allowed (using font color change or other visual clue).

I hope that this is something that can be done since it will simplify a
large portion of work and make it so only one person has to deal with it.

Barbara