View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
ufo_pilot
 
Posts: n/a
Default 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.