diary
 

Can I set up an alarm in an Excel worksheet, to notify me of an event
happening in a later worksheet? IE, can I set up worksheet 1 as Jan, and get
it to tell me of an event in worksheet 2, feb? Thanks

diary
 

Yes you can.

Couple of methods.

1 Using Conditional Formatting.

CF will tell you that you can't reference another sheet but you get around
this by creating a named range on the Feb sheet.

Select a cell in Feb worksheet that you want to monitor for the event.

InsertNameDefine. Give that cell a name like MyName

On Jan sheet select a cell.........say A1........and FormatCFFormula is:

=MyName = 123 adjust for your event or value.

Format to a color and OK your way out.

2. Using VBA event code to flash up a message box.

Post some details if you want to go with the code.


Gord Dibben MS Excel MVP

On Fri, 3 Oct 2008 08:16:17 -0700, kellers
wrote:

Can I set up an alarm in an Excel worksheet, to notify me of an event
happening in a later worksheet? IE, can I set up worksheet 1 as Jan, and get
it to tell me of an event in worksheet 2, feb? Thanks