hello!!!
is it possible to create a popup or alert message if any one of the cell meet condition with in the range of cells.
thanks
surya
hello!!!
is it possible to create a popup or alert message if any one of the cell meet condition with in the range of cells.
thanks
surya
Yes.
It's called Data Validation (menu:Data>Validation)
Example 1:
Allow:
Whole Number: Between
Minimum: 100
Maximum: 300
Example 2:
Allow
Custom =AND(D1>100,D1<300)
Hope it helped
Ola Sandström
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks