Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a "flags" or "reminders" be used in a ws
Excell version 2002-Can you set up a worksheet to flash a "flag" or
"reminder" that the user needs to update another worksheet in the same workbook. I am a new user to excell and am still struggling. Thanks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a "flags" or "reminders" be used in a ws
You could probably use Conditional Formatting to accomplish this. For
example, have a certain cell or cells turn red until the other sheet has been updated. Or, you could write a formula to display a reminder message in a cell if updates aren't complete. Or you could even use VB code for more complex situations. We would need to know more about your spreadsheet to offer more specific advice though. HTH, Elkar "gidawie1" wrote: Excell version 2002-Can you set up a worksheet to flash a "flag" or "reminder" that the user needs to update another worksheet in the same workbook. I am a new user to excell and am still struggling. Thanks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a "flags" or "reminders" be used in a ws
You could try this:
scroll over the cells you need the flags to show up then: DataValidationInput Message you can imbellish it also with the error message this will now cause this error message to show up on every cell you scrolled over prior, every time one of the cells is selected there are of course much better ways, but this is a simple way especially if you are not too familiar with all excel has to offer yet. "Elkar" wrote: You could probably use Conditional Formatting to accomplish this. For example, have a certain cell or cells turn red until the other sheet has been updated. Or, you could write a formula to display a reminder message in a cell if updates aren't complete. Or you could even use VB code for more complex situations. We would need to know more about your spreadsheet to offer more specific advice though. HTH, Elkar "gidawie1" wrote: Excell version 2002-Can you set up a worksheet to flash a "flag" or "reminder" that the user needs to update another worksheet in the same workbook. I am a new user to excell and am still struggling. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|