Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Another way... Use a custom number format in the cell with the formula. The formula might look like... =A5-B5 The cell number format could look like... [Red][<0]"Reimbursable data does not equal!";[Blue][=0]0;@ -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "stacy05" wrote in message I don't know if this is possible in Excel, but here is what I want to do. I want to create a "check" for the users. Basically 2 cells need to equal eachother before they can sumbit the worksheet. What I would like to happen is if the 2 cells don't equal a dialog block pops up saaying "Reimbursable data does not equal!!". Is this possible? Thanks in advance! Stacy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
dialog boxes | Excel Discussion (Misc queries) | |||
Using Dialog Boxes | Excel Worksheet Functions | |||
Dialog Boxes | Excel Discussion (Misc queries) | |||
Dialog boxes | Excel Discussion (Misc queries) | |||
How can I change the size of dialog boxes? | Excel Discussion (Misc queries) |