If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
change cell colour according to date.....
Hello I would be very grateful if anyone could help pont me in the right
direction with a formula to do the following: I have a date in field D9 and I need field I9 fill colour to change to orange if today’s date is greater than 20 days after the date in D9 and then turn red if today’s date is greater than 28 days after the date in D9 I hope this makes sense, I am not to hot at excel at the moment but am trying to learn Many Thanks Rich |
#2
|
|||
|
|||
change cell colour according to date.....
This can be achieved using Conditional Formatting - see here for more info:
http://www.contextures.com/xlCondFormat01.html To colour as you require you require two conditions in I9: first =TODAY()$D$9+28 set colour as red and second =$I$9$D$9+20 set colour as orange You could of course use two cells remote from your workings enter 20 in one and 28 in the other and use those cell references in the formulae, that way you can, if required, easily change the number of days difference! Hope this helps "RichLive" wrote: Hello I would be very grateful if anyone could help pont me in the right direction with a formula to do the following: I have a date in field D9 and I need field I9 fill colour to change to orange if today’s date is greater than 20 days after the date in D9 and then turn red if today’s date is greater than 28 days after the date in D9 I hope this makes sense, I am not to hot at excel at the moment but am trying to learn Many Thanks Rich |
#3
|
|||
|
|||
change cell colour according to date.....
Click on I9 and open the Conditional Formatting dialog (in Excel 2007
looking in the Styles group on the Hone tab; in earlier versions open the Format dropdown on main menu). First use the rule / Formula Is: =TODAY()-D929 and format for red Then add a second rule ? Formula Is: =TODAY()-D920 and format for orange See conditional formatting http://www.contextures.com/xlCondFormat01.html best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "RichLive" wrote in message ... Hello I would be very grateful if anyone could help pont me in the right direction with a formula to do the following: I have a date in field D9 and I need field I9 fill colour to change to orange if today's date is greater than 20 days after the date in D9 and then turn red if today's date is greater than 28 days after the date in D9 I hope this makes sense, I am not to hot at excel at the moment but am trying to learn Many Thanks Rich |
Thread Tools | |
Display Modes | |
|
|