Excel color codingClosed

Question

Hello, 

I am working on a problem that I can't fix.  I want to type in a cell a date like say 12/01/2012.  Then 30 days before this date I want it to fill yellow.  Then ,on this date I want it to fill red. These are alerts I need.  Also, if possible,  can I associate the formula with a name.  For example, Ed needs to take the course on 12/01/2012.  30 days before the date, Ed and the date have a yellow fill.  then on the date both have a red fill.  Is any of this possible?   

Thanks so much,
Ed  (using Excel 2007 and windows 7)

Configuration: Windows XP / Internet Explorer 8.0

TrowaD · Answer

Hi Ed, 

Start by selecting all the cells you want to color. In your case the cell containing the name and the cell containing the date (I used cell B1 for the date). 
Then goto the top menu's > format > conditional format. 

For condition 1 select "formula is" and enter: 
=$B$1=TODAY() 
Select the color you want (red). 

For condition 2 select "formula is" and enter: 
=$B$1-30<=TODAY() 
Select the color you want (yellow). 

Best regards, 
Trowa

Excel color coding

1 response

Similar discussions

Subscribe To Our Newsletter!