| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I create a prompt box?
Im trying to create promote box in excel to show that 3 months before the
expiry date. To say that 3 months before expiry consider for renewing. Then a day before expiry 1 day before pass expiries And after the expiry date Need reviewing Column C2:C90 are were the dates are stored and need to do a promote box with these 3 conditions. And would like to have a promote box appear with the name and expiry showing or even to colour the cell when 3 month before, 1 day before and after the expiry date |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I create a prompt box?
You may be looking for a conditional format. Take a look here for information
http://www.mvps.org/dmcritchie/excel/condfmt.htm -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "trevor" wrote: Im trying to create promote box in excel to show that 3 months before the expiry date. To say that 3 months before expiry consider for renewing. Then a day before expiry 1 day before pass expiries And after the expiry date Need reviewing Column C2:C90 are were the dates are stored and need to do a promote box with these 3 conditions. And would like to have a promote box appear with the name and expiry showing or even to colour the cell when 3 month before, 1 day before and after the expiry date |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a prompt box? | Setting up and Configuration of Excel | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| Prompt user to create routing slip | Excel Worksheet Functions | |||
| Create a prompt as a person saves a file | Excel Worksheet Functions | |||
| Help on Prompt | Excel Worksheet Functions | |||
Linear Mode
