how to add alerts in excel sheet?

Question

how to add alerts in excel sheet .example . Passport expiry date or working visa expiry date...

Answer 1

Start Microsoft Excel.

Press ALT+F11 to start the Visual Basic Editor.

On the Insert menu, click Module.

Type the following code into the module sheet



Option Explicit

'Message Function

Function AlertMessage(Text)

MsgBox (Text)

End Function



To call use

=AlertMessage("Hello")



You may have to change your security settings if you open up the spreadsheet again.

This formula can now be used with an IF().



Have fun.

Answer 2

The simplest means is more commonly to make use of conditional formatting to spotlight in pink the ones cells that include the phrase Fail. To do that: one million. Select the entire cells in column K two. From the Ribbon, pick Home -> Conditional Formatting -> Highlight Cells Rules -> Equal To... three. Type within the phrase Fail into the primary field. four. Select the formatting you wish to make use of from the drop down record. five. Click OK You will have to now uncover that any cells containing the phrase fail shall be highlighted in a further color. Hope this is helping.

Answer 3

The function TODAY() returns the current date. So you need to compare your expiry date with TODAY() with an IF function. If TRUE then it will return one value and if FALSE will return another value. I think you can use this value to make the cell, for example, turn red or blue.