If you are using Excel 2007, then you can do part of this without VBA. If
you want to change color of cell, for example, when the cell value is
negative, you can accomplish this by going to Home > Conditional Formatting
and then creating a rule by which the cell changes. This is probably easier
than fiddling with VBA to accomplish the same thing.
To tackle your year question, I would probably figure out how to write a
subroutine that would be activated upon a change in the worksheet. Whenever
you make a change, this subrouting would be triggered to run. I would then
run a loop using the range.offset property such that the loop counter is
used to run down the rows and perform an algorithm on each row to check the
value and copy your year.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel