I have a range of cells with moving data in them.
G5,G6, I5,I6, K5,K6, M5,M6, O5,O6, Q5,Q6
Then its the same again for rows 8,9, 11,12, 14,15, 17,18, 20,21,
Each of those 84 cells have moving data in them.
I have conditional formatting for each cell to change interior color when value is greater than 100.
Now - i also
would like an audible alert when this condition is met too.
So far the code is as follows:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static aboveLimit As Boolean
If 100 < Application.Min(Range("G5:O5")) Then
If Not (aboveLimit) Then Call sndPlaySound32("C:documents and settings" & Environ("USERNAME") &
aboveLimit = True
aboveLimit = False
Now the problem is that if i change range to G:G, for example, if any of those cells in column G are NOT above 100 than there
will be no beep if any of the other cells in that range meet the above criteria....
So therefore, I need to modify
the above code to look at every cell individually instead in the range of (G:G, I:I, K:K, M:M, O:O, Q:Q).
anyone help me with this please?
I have tried like almost 50 different things but cant get it to work for me.
Looking forward to anyone's kind help
I have even tried ranging ("G5, I5, K5, M5, O5, Q5, G6, I6, K6, M6, etc, etc, etc") for all 84 cells
but it does not seem to apply to each cell individually.
I also tried adding a: for each cell in range : but this just gave me errors...
THanks in advance.