Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell be changed on a certain date
I have Excel 2003 and I want a cell to change colors when the date i put in
the cell is within six months of todays date. Is this possible? if A1 has 12NOV08 and A2 has 12NOV09 how can I get A2 to change to red when its six months from todays date |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell be changed on a certain date
Please follow following steps
1.Set the cells A1 and A2 to display date format as:- select the cell right click format cells number tab select date from category list select 03/14/01 from type list click ok 2.Now select A2 and click formatconditional formatting from the toolbar 3.In the dialog box, select cell value is from the left drop down list 4.select between from the middle drop down list 5.enter =$A$1 in the box to the between drop down list 6. enter =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) to the last box 7.click format button and choose your color 8. click ok Now you are done!...... Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell be changed on a certain date
As a matter of interest, Chris, why have you done step 1, changing the
format of the date display? Wouldn't the CF work regardless of what the date format display is? The only logic I can see in changing the date format would be to spot if it doesn't change, which would then tell you that the date contained text, rather than a date, but if that was your logic in trying the format change, you'd probably need to tell the OP what to do with the text if that is what your test found. -- David Biddulph "Chris Bode via OfficeKB.com" <u49096@uwe wrote in message news:90feb084e3c6a@uwe... Please follow following steps 1.Set the cells A1 and A2 to display date format as:- select the cell right click format cells number tab select date from category list select 03/14/01 from type list click ok 2.Now select A2 and click formatconditional formatting from the toolbar 3.In the dialog box, select cell value is from the left drop down list 4.select between from the middle drop down list 5.enter =$A$1 in the box to the between drop down list 6. enter =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) to the last box 7.click format button and choose your color 8. click ok Now you are done!...... Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto enter current date in cell when another changed | Excel Worksheet Functions | |||
STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL | Excel Discussion (Misc queries) | |||
Insert date when a cell is changed | Excel Discussion (Misc queries) | |||
How to auto insert date in one cell when another is changed | Excel Worksheet Functions | |||
can i see the date the last time a cell was changed? | New Users to Excel |