Spreadsheet: 48189d1247442991-help-with-a-pop-up-msg-modified-test2-from-flds
Sheet: Sheet2

 |  |  |  | WK1 | WK2 | WK3 | WK4 | WK5 | WK6
 |  |  |  | -1 | -2 | -1 | -2 | 8 | -2 |  | [NAME]'s Notes:
 |  |  |  | -1 | -2 | -1 | -2 | 8 | -2 |  | The macro relies on any "spacer rows" (eg rows 26 & 27) being in sets of two.
 |  |  |  | -2 | -5 | -1 | 15 | -6 | -1 |  | I have deleted row 234 from the downloaded file because it made a set of 3 spacer rows.
 |  |  |  | -3 | -7 | -2 | 13 | 2 | -3 |  | I have created a named range, "InputRng" for use in the macros.
 |  |  |  | -1 | -1 | -1 | -8 | -2 | 13 |  | I've modifed the Conditional Formatting to allow copying over all rows - although this may cause the file to become slower in responding.
 |  |  |  | -4 | -8 | -3 | 5 | 0 | 10 |  | I attempted to modify the Conditional formatting for rows 8 & below but I couldn't easily make it flexible for different "required weeks"
 |  |  |  | -1 | -1 | -2 | -6 | -9 | 19 |  | [NAME] (these are defined as named ranges):
 |  |  |  | -5 | -9 | -5 | -1 | -9 | 29 |  | Threshold Value: |  | 1
 |  |  |  | -8 | 21 | -1 | -6 | -3 | -3 |  | Required Weeks In A Row: |  | 3
 |  |  |  | -13 | 12 | -6 | -7 | -12 | 26 |  | Number of Header Rows: |  | 1
 |  |  |  | -1 | -1 | 13 | -2 | -8 | -1
 |  |  |  | -14 | 11 | 7 | -9 | -20 | 25
 |  |  |  | -2 | -6 | 3 | -6 | 18 | -1 |  | ################################################################################
 |  |  |  | -16 | 5 | 4 | -15 | -2 | 24 |  | In A8 when I enter a value > 1, I need a pop-up message "THIRD WEEK"  only if A4 and A6 is red with positive value.
 |  |  |  | -6 | -6 | 24 | -6 | 5 | -11 |  | If either A4 or A6 has a negative value the message should not pop-up.
 |  |  |  | -22 | -1 | 28 | -21 | 3 | 13 |  | (if possible the message to read "THIRD WEEK + WK1" [WK1 = column heading] would be prefered)
 |  |  |  | 19 | -11 | -11 | -11 | 27 | -13 |  | Message to pop-up when return is clicked
 |  |  |  | -3 | -12 | 17 | -32 | 30 | 0
 |  |  |  | -8 | -1 | -1 | 20 | -9 | -1
 |  |  |  | -11 | -13 | 16 | -12 | 21 | -1
 |  |  |  | -1 | 8 | -1 | -2 | -2 | -2
 |  |  |  | -12 | -5 | 15 | -14 | 19 | -3
 |  |  |  | -7 | -5 | -1 | 15 | -1 | -1
 |  |  |  | -19 | -10 | 14 | 1 | 18 | -4
 |  |  |  | 5 | -1 | -1 | -1 | -1 | -1
 |  |  |  | 5 | -1 | -1 | -1 | -1 | -1
 |  |  |  | -1 | -1 | -1 | -1 | 5 | -1
 |  |  |  | 4 | -2 | -2 | -2 | 4 | -2
 |  |  |  | -7 | -1 | -1 | -1 | -2 | 12
 |  |  |  | -3 | -3 | -3 | -3 | 2 | 10
 |  |  |  | -1 | -1 | -1 | -1 | 5 | -1
 |  |  |  | -4 | -4 | -4 | -4 | 7 | 9
 |  |  |  | 7 | -1 | -2 | -1 | -2 | -1
 |  |  |  | 3 | -5 | -6 | -5 | 5 | 8
 |  |  |  | 21 | -6 | 9 | -9 | -6 | -9
 |  |  |  | 24 | -11 | 3 | -14 | -1 | -1
 |  |  |  | -4 | -1 | -6 | 13 | -1 | -1
 |  |  |  | 20 | -12 | -3 | -1 | -2 | -2
 |  |  |  | -1 | -1 | -3 | -6 | 12 | -1
 |  |  |  | 19 | -13 | -6 | -7 | 10 | -3
 |  |  |  | -7 | -5 | -9 | -12 | -6 | 39
 |  |  |  | 12 | -18 | -15 | -19 | 4 | 36
 |  |  |  | -6 | -7 | 17 | -7 | -6 | 9
 |  |  |  | 6 | -25 | 2 | -26 | -2 | 45
 |  |  |  | -6 | -13 | -6 | -10 | -6 | 41 |  | Message to pop-up when return is clicked
 |  |  |  | 0 | -38 | -4 | -36 | -8 | 86
 |  |  |  | -1 | -2 | 14 | -2 | -1 | -8
 |  |  |  | -1 | -40 | 10 | -38 | -9 | 78
 |  |  |  | -2 | 6 | -1 | -1 | -1 | -1
 |  |  |  | -2 | 6 | -1 | -1 | -1 | -1
 |  |  |  | 7 | -2 | -1 | -2 | -1 | -1
 |  |  |  | 5 | 4 | -2 | -3 | -2 | -2
 |  |  |  | -4 | -2 | 40 | -8 | -8 | -18
 |  |  |  | 1 | 2 | 38 | -11 | -10 | -20
 |  |  |  | -1 | -1 | 6 | -1 | -2 | -1
 |  |  |  | 0 | 1 | 44 | -12 | -12 | -21
 |  |  |  | -6 | -7 | -6 | -12 | -8 | 39
 |  |  |  | -6 | -6 | 38 | -24 | -20 | 18
 |  |  |  | -1 | -1 | -3 | 14 | -1 | -8
 |  |  |  | -7 | -7 | 35 | -10 | -21 | 10
 |  |  |  | -7 | -1 | -1 | -1 | -1 | 11
 |  |  |  | -14 | -8 | 34 | -11 | -22 | 21
 |  |  |  | -7 | -8 | -1 | -1 | -2 | 19
 |  |  |  | -21 | -16 | 33 | -12 | -24 | 40
 |  |  |  | -1 | -1 | 6 | -1 | -1 | -2
 |  |  |  | -22 | -17 | 39 | -13 | -25 | 38
 |  |  |  | 11 | -1 | -7 | -1 | -1 | -1
 |  |  |  | -11 | -18 | 32 | -14 | -26 | 37
 |  |  |  | -1 | -1 | -1 | -1 | 11 | -7
 |  |  |  | -12 | -19 | 31 | -15 | -15 | 30
 |  |  |  | -5 | -1 | -6 | -1 | 16 | -3
 |  |  |  | -17 | -20 | 25 | -16 | 1 | 27
 |  |  |  | -5 | -4 | -4 | -6 | -3 | 22
 |  |  |  | -5 | -4 | -4 | -6 | -3 | 22
 |  |  |  | -1 | 6 | -2 | -1 | -1 | -1
 |  |  |  | -6 | 2 | -6 | -7 | -4 | 21
 |  |  |  | -1 | 5 | -1 | -1 | -1 | -1
 |  |  |  | -7 | 7 | -7 | -8 | -5 | 20
 |  |  |  | -2 | -1 | 10 | -1 | -5 | -1
 |  |  |  | -9 | 6 | 3 | -9 | -10 | 19
 |  |  |  | -4 | -1 | -1 | 10 | -1 | -3
 |  |  |  | -13 | 5 | 2 | 1 | -11 | 16
 |  |  |  | -1 | -2 | -1 | 12 | -7 | -1
 |  |  |  | -14 | 3 | 1 | 13 | -18 | 15
 |  |  |  | -1 | -5 | 10 | -1 | -1 | -2
 |  |  |  | -15 | -2 | 11 | 12 | -19 | 13
 |  |  |  | -1 | -1 | -2 | -8 | -8 | 20
 |  |  |  | -16 | -3 | 9 | 4 | -27 | 33
 |  |  |  | 5 | -1 | -1 | -1 | -1 | -1
 |  |  |  | -11 | -4 | 8 | 3 | -28 | 32
 |  |  |  | -6 | -6 | 1 | -6 | 23 | -6
 |  |  |  | -17 | -10 | 9 | -3 | -5 | 26
 |  |  |  | 5 | -8 | -6 | 24 | -8 | -7
 |  |  |  | -12 | -18 | 3 | 21 | -13 | 19
 |  |  |  | -1 | -1 | -1 | -1 | -2 | 6
 |  |  |  | -13 | -19 | 2 | 20 | -15 | 25
 |  |  |  | -1 | -1 | -1 | -1 | -2 | 6
 |  |  |  | -1 | -1 | -1 | -1 | -2 | 6
 |  |  |  | -1 | -1 | -1 | -1 | 5 | -1
 |  |  |  | -2 | -2 | -2 | -2 | 3 | 5
 |  |  |  | -8 | -2 | -1 | -1 | -1 | 13
 |  |  |  | -10 | -4 | -3 | -3 | 2 | 18
 |  |  |  | -7 | -1 | -1 | -1 | 18 | -8
 |  |  |  | -17 | -5 | -4 | -4 | 20 | 10
 |  |  |  | -1 | -1 | -2 | 8 | -3 | -1
 |  |  |  | -18 | -6 | -6 | 4 | 17 | 9
 |  |  |  | -2 | -1 | -1 | 7 | -2 | -1
 |  |  |  | -20 | -7 | -7 | 11 | 15 | 8
 |  |  |  | -1 | -1 | -5 | -1 | 10 | -2
 |  |  |  | -21 | -8 | -12 | 10 | 25 | 6
 |  |  |  | -1 | -1 | -5 | -1 | 9 | -1
 |  |  |  | -22 | -9 | -17 | 9 | 34 | 5
 |  |  |  | -1 | -1 | -1 | 5 | -1 | -1
 |  |  |  | -23 | -10 | -18 | 14 | 33 | 4
 |  |  |  | -1 | -1 | -1 | -1 | -2 | 6
 |  |  |  | -24 | -11 | -19 | 13 | 31 | 10
 |  |  |  | 18 | -7 | -1 | -6 | -3 | -1
 |  |  |  | -6 | -18 | -20 | 7 | 28 | 9
 |  |  |  | -1 | -1 | -1 | -1 | 5 | -1
 |  |  |  | -7 | -19 | -21 | 6 | 33 | 8