| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date sensitive cell pattern color
Greetings,
How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date sensitive cell pattern color
hi, Darrell,
try to use conditional format (Fomart | Conditional Format) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Darrell Shuman" escreveu: Greetings, How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date sensitive cell pattern color
Thanks Marcelo, but how can I enter some future date and when that date
comes the cell turns red? I can't find a way to enter the IF and DATE function in the conditional format. ds "Marcelo" wrote in message ... hi, Darrell, try to use conditional format (Fomart | Conditional Format) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Darrell Shuman" escreveu: Greetings, How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date sensitive cell pattern color
1. Select the cell in question
2. Select Format-Conditional Formatting 3. Select "Formula Is" 4. Enter this formula =TODAY()=DATEVALUE("8/15/2006") 6. Click Format, and select the pattern you want. 7. Click Ok Replace 8/15/2006 with the date you want to use, but be sure to keep the quotes around the date. If the date is in the cell then use the cell reference in the formula like this... =TODAY()=A1 or use "Cell Value Is" - "Less than or equal to" - =TODAY() Whichever way you choose the cell pattern will change when the current date has reached the date in question. "Darrell Shuman" wrote: Greetings, How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date sensitive cell pattern color
That did it. Thank you very much.
ds "Sloth" wrote in message ... 1. Select the cell in question 2. Select Format-Conditional Formatting 3. Select "Formula Is" 4. Enter this formula =TODAY()=DATEVALUE("8/15/2006") 6. Click Format, and select the pattern you want. 7. Click Ok Replace 8/15/2006 with the date you want to use, but be sure to keep the quotes around the date. If the date is in the cell then use the cell reference in the formula like this... =TODAY()=A1 or use "Cell Value Is" - "Less than or equal to" - =TODAY() Whichever way you choose the cell pattern will change when the current date has reached the date in question. "Darrell Shuman" wrote: Greetings, How can I set up a cell's pattern color to automatically change to red when a certain date arrives? I would hope it could be done without VB as my knowledge is very limited. Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference Cell Color From Other WorkSheets | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
