Creating a popup box if certain cells remain empty

andrewb90

Well-known Member
Joined
Dec 16, 2009
Messages
1,077
Hello all,

Is it possible to add some conditional formatting to a group of cells to have a popup box appear with a message in it if a certain cell (on a different sheet) does not have any data entered into it? Additionally can I make a popup appear if the numerical value of a cell exceeds or falls below a certain amount?

Thanks,

Andrew
 
Cool that works, but mostly because I had accidentally merged D1 with B1 and C1 and had to unmerge them to make it work. :)

Also If I wanted to have only certain text phrases entered into D1 could I have say three different phrases that would only be allowed (i.e, big, small, medium)?
 
Upvote 0

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Also If I wanted to have only certain text phrases entered into D1 could I have say three different phrases that would only be allowed (i.e, big, small, medium)?

Instead of using the DV Formula Option choose..

Allow: List
Source: big,small,medium

Alternatively, for Source: you can select a range of three cells that has those 3 strings as their values.
 
Upvote 0

Forum statistics

Threads
1,224,621
Messages
6,179,946
Members
452,950
Latest member
bwilliknits

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top