diary

[kellers]

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

 

[Gord Dibben]

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.

Insert>Name>Define. Give that cell a name like MyName

On Jan sheet select a cell.........say A1........and Format>CF>Formula 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