Finding Values and Conidtionally Formatting them Based on Ranges with VBA

turner38

New Member
Joined
Jul 6, 2011
Messages
32
Hello All,

I have the following data sets:

Excel Workbook
ABCDEFGHIJKL
1NameScoreTimePlaceValidation TableScoreScoreTimeTimePlacePlace
2Steve9534LowHighLowHighLowHigh
3John913.55Steve801001582
4Kevin9823John751001482
5Dennis1001.51Kevin901001682
6Rick854.57Dennis951002682
7Jeff8846Rick801000.5682
8Paul7558Jeff80900.5682
9Peter991.72Paul78900.5671
10Robert1001.51Peter87902471
11Robert89901371
Sheet1
Excel 2007



I want to use VBA to automatically flag data in the left table for values under the "Score", "Time", and "Place" columns that fall outside (either below the low value or above the high value) the ranges set for each person in the validation table (Righ-side table). The flag data I want to show by bolding the font and changing the font color to red.

My plan is to use this function to automatically audit my data set for good data integrity. I will have about 10,000+ lines of data so I really prefer to use VBA if possible. I know I could manually set the conditional format but I will be constantly loading new data to the sheet each week and want this feature to automatically flag the "abnormal" data after I paste it.

I have looked at some threads and I think the Find function in VBA will help locate the value, but I don't know how to tie in the ranges and conditional format.

Any help, thoughts, or comments are greatly appreciated!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Try this:-
Code:
[COLOR="Navy"]Sub[/COLOR] MG19Aug33
[COLOR="Navy"]Dim[/COLOR] Rng     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn      [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Rng1    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Rng2    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Ac      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] nAc     [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Temp1   [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Temp2   [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Set[/COLOR] Rng1 = Range(Range("A2"), Range("A" & Rows.Count).End(xlUp))
[COLOR="Navy"]Set[/COLOR] Rng2 = Range(Range("F3"), Range("F" & Rows.Count).End(xlUp))
[COLOR="Navy"]Set[/COLOR] Rng = Union(Rng1, Rng2)
[COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
    .CompareMode = vbTextCompare
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        [COLOR="Navy"]If[/COLOR] Not .Exists(Dn.Value) [COLOR="Navy"]Then[/COLOR]
            .Add Dn.Value, Dn
        [COLOR="Navy"]Else[/COLOR]
            [COLOR="Navy"]For[/COLOR] Ac = 1 To 3
                [COLOR="Navy"]If[/COLOR] Ac = 2 [COLOR="Navy"]Then[/COLOR]
                    nAc = 3
                    Temp1 = Dn.Offset(, nAc)
                    Temp2 = Dn.Offset(, nAc + 1)
                [COLOR="Navy"]ElseIf[/COLOR] Ac = 3 [COLOR="Navy"]Then[/COLOR]
                    nAc = 5
                    Temp2 = Dn.Offset(, nAc)
                    Temp1 = Dn.Offset(, nAc + 1)
                [COLOR="Navy"]Else[/COLOR]
                     nAc = Ac
                     Temp1 = Dn.Offset(, nAc)
                     Temp2 = Dn.Offset(, nAc + 1)
                [COLOR="Navy"]End[/COLOR] If
       
       [COLOR="Navy"]If[/COLOR] .Item(Dn.Value).Offset(, Ac) < Temp1 Or .Item(Dn.Value).Offset(, Ac) > Temp2 [COLOR="Navy"]Then[/COLOR]
            [COLOR="Navy"]With[/COLOR] .Item(Dn.Value).Offset(, Ac)
                .Font.ColorIndex = 3
                .Font.Bold = True
            [COLOR="Navy"]End[/COLOR] With
        [COLOR="Navy"]End[/COLOR] If
    [COLOR="Navy"]Next[/COLOR] Ac
[COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]With[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Mick,

Thanks for code. It works but the ranges are not being followed. When I run the macro it flags numbers that are in the range and it does not flag numbers that are outside the range.

My complete spreadsheet that I am using is bigger than the one I posted as an example. My data is in columns F through N and my Validation table is in columns AB through AR. I changed the macro for to these columns. Is there something I am missing? My two tables are setup the same as in the example I gave just the are more columns with data that doesn't need to be validated.

Thanks,
 
Upvote 0
I should probably add that the "Name" portion of the left-side table will not always be in the same order. I think this might be throwing the macro off because in the example I gave the left side table and validation table the "names" match up in terms of order. In my spreadsheet, the order of the "names" in the validation table are fixed where as the order of the "names in the left-side table are going change everytime I load new data in.
 
Upvote 0
The sequence of names, one list to the other should not matter.
This is you basic Data with "Peter" moved to the top to reflect the sentence above, the result is not quite like your original post, but I think it is correct.
If you would like to try the code with the 2 data sets starting in column "A" & Column "F" as per you original post, then if that works for you , I'll alter the code to reflect the new ranges.
<TABLE style="WIDTH: 545pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=726 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 804" width=22><COL style="WIDTH: 48pt" span=7 width=64><TBODY><TR style="HEIGHT: 39pt" height=52><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 39pt; BACKGROUND-COLOR: white" width=64 height=52>Name</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Score</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Time</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Place</TD><TD class=xl26 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Validation Table</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Score</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Score</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Time</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Time</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Place</TD><TD class=xl30 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Place</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Peter</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>99</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1.7</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64></TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Low</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>High</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Low</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>High</TD><TD class=xl25 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Low</TD><TD class=xl30 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>High</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Steve</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>95</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>3</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>4</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Steve</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>80</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>5</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>John</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>91</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>3.5</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>5</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>John</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>75</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>4</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Kevin</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>98</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>3</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Kevin</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>90</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Dennis</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1.5</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Dennis</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>95</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Rick</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>85</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>4.5</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>7</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Rick</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>80</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>0.5</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Jeff</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>88</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>4</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Jeff</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>80</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>90</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>0.5</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Paul</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>75</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>5</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>8</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Paul</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>78</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>90</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>0.5</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>6</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>7</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18>Robert</TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>100</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1.5</TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl36 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64>Peter</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>87</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>90</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>2</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>4</TD><TD class=xl28 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>7</TD><TD class=xl31 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD class=xl27 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=64 height=18></TD><TD class=xl29 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl35 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 1pt solid; BACKGROUND-COLOR: white" width=64> </TD><TD class=xl37 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #e0dfe3; WIDTH: 17pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=22> </TD><TD class=xl32 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64>Robert</TD><TD class=xl33 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>89</TD><TD class=xl33 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>90</TD><TD class=xl33 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>1</TD><TD class=xl33 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>3</TD><TD class=xl33 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" width=64 x:num>7</TD><TD class=xl34 style="BORDER-RIGHT: #666699 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #666699 1pt solid; BACKGROUND-COLOR: white" align=right x:num>1</TD></TR></TBODY></TABLE>

Regards Mick
 
Upvote 0
Mick,

I uploaded a sample of my worksheet to box.net. Here is the link.

http://www.box.net/shared/jz6yfydm989yrqrgkhgn

I tried testing the code with the orginial format I posted (the 2 tables starting in columns A and F). I copied and pasted your code and got a mis-match error.

When I adjusted your code to fit my actual spreadsheet, again it works but the ranges are not being followed. Data is flagged that is in range and data that is out of range is not being flagged.

My data table in the file above is from columns F through N. My validation table is in columns AB through AR. I am using the "validate data" button to execute the macro.

I guess I did not adjust the macro correctly. Also, it is possible to place a "X" in column O for a row that contains any flagged data? I really like how the data is in red that fall outside the ranges, but I am thinking I will also need the X's so I can filter the data set to just show the rows that need correction.

Sorry to being asking so much. I really appreciate any help you can provide.
 
Upvote 0
Try this:-
Code:
[COLOR="Navy"]Sub[/COLOR] MG22Aug49
[COLOR="Navy"]Dim[/COLOR] Rng     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn      [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Rng1    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Rng2    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] c       [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
Application.ScreenUpdating = False
[COLOR="Navy"]Set[/COLOR] Rng1 = Range(Range("F2"), Range("F" & Rows.Count).End(xlUp))
[COLOR="Navy"]Set[/COLOR] Rng2 = Range(Range("AB3"), Range("AB" & Rows.Count).End(xlUp))
    [COLOR="Navy"]With[/COLOR] Rng1.Resize(, 4)
        .Font.ColorIndex = 1
        .Font.Bold = False
    [COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]Set[/COLOR] Rng = Union(Rng2, Rng1)
[COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
    .CompareMode = vbTextCompare
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
        [COLOR="Navy"]If[/COLOR] Not .Exists(Dn.Value) [COLOR="Navy"]Then[/COLOR]
            [COLOR="Navy"]If[/COLOR] Dn.Column = 28 [COLOR="Navy"]Then[/COLOR]
            .Add Dn.Value, Array(Dn(, 2), Dn(, 3), Dn(, 4), Dn(, 5), Dn(, 6), Dn(, 7))
            [COLOR="Navy"]End[/COLOR] If
        [COLOR="Navy"]Else[/COLOR]
           [COLOR="Navy"]If[/COLOR] Dn.Column = 6 [COLOR="Navy"]Then[/COLOR]
                c = 3
                q = .Item(Dn.Value)
                [COLOR="Navy"]For[/COLOR] n = 2 To 4
                    c = c - 1
                    [COLOR="Navy"]If[/COLOR] Dn(, n) < q(n - c) Or Dn(, n) > q(n - c + 1) [COLOR="Navy"]Then[/COLOR]
                         [COLOR="Navy"]With[/COLOR] Dn(, n)
                            .Font.ColorIndex = 3
                            .Font.Bold = True
                        [COLOR="Navy"]End[/COLOR] With
                    [COLOR="Navy"]End[/COLOR] If
                [COLOR="Navy"]Next[/COLOR] n
            [COLOR="Navy"]End[/COLOR] If
    [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] With
Application.ScreenUpdating = True
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Regards Mick
 
Upvote 0
Mick,

The ranges work for Columns G through I (Score, Rank, Results), but for columns J through N (Time, Time-adjusted, Rank-adjusted, Units, Sales) they do not seem to be flagging any data.

Have I missed a step? Also, would it be possible to place a "X" in column O if any data in columns G through N is flagged. Basically I want to use this for filter purposes, so once I validate the data I can filter to only show rows that contain data that needs to be corrected.

Thanks,
 
Upvote 0

Forum statistics

Threads
1,224,597
Messages
6,179,808
Members
452,944
Latest member
2558216095

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top