ExcelBanter - how to apply Warning massage

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to apply Warning massage (https://www.excelbanter.com/excel-discussion-misc-queries/263248-how-apply-warning-massage.html)

Deepak

how to apply Warning massage

how to apply Warning massage so that a wrning massage should pop-up while
comparing two mismatched values

Jacob Skaria

how to apply Warning massage

Can you elaborate; preferably with an example? How would you like to compare
the values?

'This is not a popup...
=IF(A1<B1,"Mismatch","")

--
Jacob (MVP - Excel)

"deepak" wrote:

how to apply Warning massage so that a wrning massage should pop-up while
comparing two mismatched values

bala_vb

Quote:

Originally Posted by Jacob Skaria (Post 951753)

If you considering case sensitiveness of strings use EXACT Function

=IF(EXACT(A1,B1),"","MisMatch")

Ex: "Strange" is not equal to "STRANGE"

all the best

dlw

how to apply Warning massage

use Data \ Validation on one of the cells to make sure it matches the other
cell

"deepak" wrote:

how to apply Warning massage so that a wrning massage should pop-up while
comparing two mismatched values

All times are GMT +1. The time now is 02:26 AM.