Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help please - warning messages
I am trying to put a warning message on cell that will pop up if the value of
that cell is not the same as the value of another cell. (using data validation). My problem is that the cell I am trying to put the warning on has a vlookup formula in it and therefore the warning message does not work. Is there a way to do this? Please help!! Thanks, Angela |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help please - warning messages
A simple way which could be as effective is to use a formula in an adjoining
cell Assuming the vlookup is in A1, with its return to be compared with D1 You could use in B1: =IF(A1<D1,"< Re-check!","") and format B1 in red & bold -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "adickson" wrote: I am trying to put a warning message on cell that will pop up if the value of that cell is not the same as the value of another cell. (using data validation). My problem is that the cell I am trying to put the warning on has a vlookup formula in it and therefore the warning message does not work. Is there a way to do this? Please help!! Thanks, Angela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help please - warning messages | Excel Worksheet Functions | |||
Warning Messages | Excel Worksheet Functions | |||
Excel hyperlinks - disabling warning messages | Links and Linking in Excel | |||
How to prevent warning messages on protected work sheet. | Excel Worksheet Functions | |||
Msg.box -messages | Excel Discussion (Misc queries) |