New to this thread, but I am looking for major help, I will try to be as descriptive as possible.
What I am looking to do is have a cell autopopulate a given date, based off the date in a previous cell. I want to add 1 year to the date. What I am also looking to be done, is that if the autopopulated date is within the present month, ie. December, the cell will show up as the color Red. If the autopopulated date is 1 months ahead of the present month, I want that cell the show up as Blue. If the autopopulated date is 2 months ahead of the present month, I want that cell the show up as Yellow. My best attempts at this so far have been the following:
if cell A1 is 12/01/2010, have B1 as =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1)).
now this will get me to autopopulat the correct date that am looking for. But i have not been able to figure out how to color the cell based off the month.
I do not know how to make the computer understand what today's date is and then generate a color.
This is what i am looking to do:
A1B1
12/01/201012/01/2011
01/01/201101/01/2011
02/01/201102/01/2011
any help on this would be much appreciated.
Bookmarks