Pop up message needed dependend on certain conditions
In cell range C7:C14 the cells can have different values (1, 2, 3, .....)
In case there is only 1 kind of value (only value 1, or only value 2) I'd like to get a message (pop up, or in a certain cell), which says "blablabla"
I'd like to get different messages for different values, though.
For example: C7 = 1
C8 = 1
C9 = 1
Message to pop up: "Please be aware that pattern repeat to be divisible by 4"
C7 = 2
C8 = 2
C9 = 2
C10 = 2
Message to pop up: "Please be aware that pattern repeat to be divisible by 12"
For example: C7 = 1
C8 = 2
C9 = 1
No message to pop up
|