if cell contains specific text how to make a pop up window or even image - formula only (no macro)

IsabellaLearning

Board Regular
Joined
May 23, 2009
Messages
115
Hi all,

In my workbook if column D contains the word "Action" I would like a pop up box to appear with a message.

As the workbook is going on sharepoint which does not execute macros the solution must be formul based.

Is this possible?



Isabella
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,109,461
Messages
5,528,935
Members
409,847
Latest member
Foster034
Top