Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
Hey. Heres what I want to do: I have a worksheet that has dates of when I need to do things, kind of like a calender. Is there a way to change the color of the text when the date approaches? Please help me! -- Rangerbob86 ------------------------------------------------------------------------ Rangerbob86's Profile: http://www.excelforum.com/member.php...o&userid=35465 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
Rangerbob86, You can use conditional formatting. Select a cell where your dates are say A1 then click on the Format menu. Select Conditional Formatting. Change the Cell value is option to Formula is: For Condition one try this if your date is less than 5 days from today. =(A1-TODAY())<5 Select FormatPatterns and select your color. Click OK and OK. Copy the format to the other cells in your range. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
hey thanks! that worked. Now, is there also a way to get the formatting to go away, once the date has passed? -- Rangerbob86 ------------------------------------------------------------------------ Rangerbob86's Profile: http://www.excelforum.com/member.php...o&userid=35465 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
This should work. =AND((A1-TODAY())<5,(A1-TODAY())=0) Cheers, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
great! so that works....but is there a way to copy and paste the conditional formatting to each of my cells that contain dates? because i think in your formula you have to change A1 to whatever cell it is, right? so do I have to do each one manually? -- Rangerbob86 ------------------------------------------------------------------------ Rangerbob86's Profile: http://www.excelforum.com/member.php...o&userid=35465 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change data in a cell, based on the date
You can use the Format Painter. Select the first cell in your range. Click on the Format painter (looks like a paint brush). While holding down the left mouse button, highlight the rest of your range and release. Or you could go to the first cell in your range (assuming it is a column) move the mouse over the lower right hand corner of the first cell until it changes to a black cross and double click. That will copy it down the range. Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=552429 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell date format doesnt change | Excel Worksheet Functions | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
How do I change the value in cell based on a future date | Excel Discussion (Misc queries) |