Conditional formatting

RAJESH1960

Banned for repeated rules violations
Joined
Mar 26, 2020
Messages
2,313
Office Version
  1. 2019
Platform
  1. Windows
I am trying to format the color of cells using confitional formatting. If on a particular date, in the total column, there are same amounts then it should color the cell. I tried sorting the data by total, that way it would be easier to find out if the common amounts have the same date. But was not able to solve it. Is there a way to apply conditional formatting to this.?


MrEXcel Query2.xlsx
BCDEF
1DateTotalDateTotal
201-07-202013,600.0001-07-20201.00
301-07-202013,600.0006-07-20201.00
401-07-202013,600.0013-07-20201.00
501-07-20201.0014-07-20201.00
601-07-20207,632.0014-07-20205.00
701-07-202012,200.0002-07-20206.00
801-07-2020730.0002-07-202013.04
901-07-202011,365.0009-07-202029.50
1001-07-202065,000.0006-07-202036.00
1101-07-20203,000.0013-07-202077.00
1201-07-202050,000.0002-07-2020100.00
1301-07-202011,326.0004-07-2020100.00
1402-07-202012,155.0003-07-2020104.96
1502-07-202012,155.0006-07-2020118.00
1602-07-20202,000.0007-07-2020118.00
1702-07-20203,694.0010-07-2020118.00
1802-07-2020100.0013-07-2020118.00
1902-07-20203,350.0015-07-2020118.00
2002-07-20206.0021-07-2020118.00
2102-07-202014,400.0023-07-2020118.00
2202-07-202013.0423-07-2020118.00
2302-07-202022,705.0007-07-2020140.00
2402-07-202091,445.0010-07-2020140.00
2502-07-202015,000.0029-07-2020200.00
2602-07-202011,235.0003-07-2020236.00
2702-07-202020,000.0028-07-2020250.00
2802-07-202016,829.0008-07-2020300.00
2902-07-202030,000.0024-07-2020300.00
3002-07-202016,000.0025-07-2020360.00
3103-07-20206,750.0009-07-2020380.00
3203-07-2020236.0029-07-2020380.00
3303-07-20201,100.0030-07-2020390.00
3403-07-20205,000.0027-07-2020435.00
3503-07-20206,468.0003-07-2020450.00
3603-07-20201,790.0013-07-2020475.00
3703-07-202036,470.0027-07-2020500.00
3803-07-20207,000.0031-07-2020500.00
3903-07-2020450.0029-07-2020517.00
4003-07-202010,000.0014-07-2020520.00
4103-07-20201,800.0014-07-2020520.00
4203-07-2020900.0015-07-2020520.00
4303-07-20207,210.0006-07-2020600.00
4403-07-2020104.9621-07-2020600.00
4503-07-202030,000.0014-07-2020602.40
4603-07-202015,000.0030-07-2020665.00
4703-07-202025,000.0009-07-2020680.00
4803-07-202030,000.0027-07-2020680.00
4903-07-20205,000.0015-07-2020695.00
5003-07-202012,600.0030-07-2020700.00
5103-07-202035,000.0023-07-2020709.00
5203-07-202020,000.0001-07-2020730.00
5303-07-202052,000.0004-07-2020750.00
5403-07-202010,000.0006-07-2020750.00
5503-07-202013,400.0009-07-2020825.00
5603-07-20203,000.0009-07-2020851.00
5703-07-20203,000.0004-07-2020862.00
5803-07-202031,581.0003-07-2020900.00
5904-07-20207,603.0008-07-2020900.00
6004-07-20205,003.0024-07-2020910.00
6104-07-2020100.0011-07-2020950.00
6204-07-20202,900.0026-07-2020960.00
6304-07-20201,22,500.0024-07-2020986.00
6404-07-20206,090.0009-07-2020990.00
6504-07-202010,000.0008-07-20201,000.00
6604-07-202014,375.0009-07-20201,000.00
6704-07-20202,090.0009-07-20201,000.00
6804-07-2020862.0014-07-20201,000.00
6904-07-20202,681.0003-07-20201,100.00
7004-07-20203,000.0028-07-20201,130.00
7104-07-202010,000.0006-07-20201,180.00
7204-07-202025,305.0030-07-20201,210.00
7304-07-202020,000.0005-07-20201,210.96
7404-07-202015,000.0031-07-20201,240.00
7504-07-202060,000.0023-07-20201,280.00
7604-07-202042,000.0006-07-20201,300.00
7704-07-202073,577.0013-07-20201,350.00
7804-07-2020750.0017-07-20201,350.00
7904-07-202068,009.0020-07-20201,369.00
8004-07-20204,494.0013-07-20201,400.00
8104-07-202023,400.0025-07-20201,400.00
8204-07-20202,000.0006-07-20201,500.00
8305-07-20201,210.9606-07-20201,500.00
8406-07-202036.0007-07-20201,500.00
8506-07-20201,300.0014-07-20201,500.00
8606-07-20202,208.0022-07-20201,500.00
8706-07-202028,810.0031-07-20201,500.00
8806-07-202020,000.0022-07-20201,511.00
8906-07-20201.0029-07-20201,540.00
9006-07-2020600.0022-07-20201,550.00
9106-07-202028,804.0011-07-20201,600.00
9206-07-2020750.0030-07-20201,600.00
9306-07-20201,180.0027-07-20201,781.00
9406-07-2020118.0030-07-20201,786.00
9506-07-20202,660.0003-07-20201,790.00
9606-07-20208,000.0003-07-20201,800.00
9706-07-202040,000.0014-07-20201,800.00
9806-07-202024,570.0030-07-20201,800.00
9906-07-20201,500.0023-07-20201,850.00
10006-07-202050,000.0015-07-20201,965.00
10106-07-20201,500.0002-07-20202,000.00
10206-07-202054,280.0004-07-20202,000.00
10306-07-202030,000.0020-07-20202,000.00
10407-07-20207,045.0024-07-20202,000.00
10507-07-202012,125.0010-07-20202,025.00
10607-07-20201,500.0013-07-20202,080.00
10707-07-20206,784.0029-07-20202,080.00
10807-07-2020118.0004-07-20202,090.00
10907-07-2020140.0028-07-20202,100.00
11007-07-202015,000.0010-07-20202,120.00
11107-07-202020,019.0010-07-20202,123.00
11207-07-202010,840.0030-07-20202,165.00
11307-07-202010,790.0006-07-20202,208.00
11407-07-202024,329.0030-07-20202,270.00
11507-07-202024,680.0016-07-20202,299.00
11607-07-20202,950.0011-07-20202,331.00
11707-07-202022,680.0013-07-20202,370.00
11807-07-202020,000.0029-07-20202,488.00
11907-07-20202,500.0007-07-20202,500.00
12007-07-202081,024.0025-07-20202,500.00
12107-07-202015,120.0025-07-20202,568.00
12208-07-20205,000.0014-07-20202,625.00
12308-07-20201,000.0006-07-20202,660.00
12408-07-2020900.0015-07-20202,680.00
12508-07-202012,591.0028-07-20202,680.00
12608-07-202020,999.0004-07-20202,681.00
12708-07-202040,000.0031-07-20202,800.00
12808-07-20205,439.0004-07-20202,900.00
12908-07-202021,000.0024-07-20202,930.00
13008-07-2020300.0007-07-20202,950.00
13108-07-202014,700.0001-07-20203,000.00
13209-07-2020380.0003-07-20203,000.00
13309-07-202010,000.0003-07-20203,000.00
13409-07-20204,920.0004-07-20203,000.00
13509-07-20208,052.0010-07-20203,000.00
13609-07-2020990.0011-07-20203,000.00
13709-07-2020851.0011-07-20203,000.00
13809-07-2020825.0013-07-20203,000.00
13909-07-2020680.0016-07-20203,000.00
14009-07-20201,000.0018-07-20203,000.00
14109-07-202050,000.0025-07-20203,000.00
14209-07-20201,000.0027-07-20203,000.00
14309-07-20205,630.0031-07-20203,000.00
14409-07-202029.5025-07-20203,050.00
14509-07-20205,000.0013-07-20203,150.00
14609-07-202050,000.0024-07-20203,213.00
14709-07-202050,072.0024-07-20203,341.00
14810-07-202033,606.0002-07-20203,350.00
14910-07-20202,120.0021-07-20203,500.00
15010-07-202038,313.0013-07-20203,559.00
15110-07-202025,000.0010-07-20203,565.00
15210-07-202020,000.0013-07-20203,565.00
15310-07-20203,000.0024-07-20203,585.00
15410-07-20205,000.0022-07-20203,676.00
15510-07-202020,139.0002-07-20203,694.00
15610-07-202031,040.0028-07-20203,707.00
15710-07-20202,025.0029-07-20203,710.00
15810-07-202050,000.0028-07-20203,748.00
15910-07-202010,000.0030-07-20203,860.00
16010-07-202010,785.0024-07-20204,000.00
16110-07-202028,686.0023-07-20204,438.00
16210-07-20206,012.0004-07-20204,494.00
16310-07-20202,123.0029-07-20204,500.00
16410-07-20209,996.0017-07-20204,707.00
16510-07-20203,565.0024-07-20204,775.00
16610-07-2020118.0027-07-20204,835.00
16710-07-20209,125.0013-07-20204,905.00
16810-07-2020140.0009-07-20204,920.00
16911-07-20202,331.0003-07-20205,000.00
17011-07-20203,000.0003-07-20205,000.00
17111-07-20201,600.0008-07-20205,000.00
17211-07-20205,000.0009-07-20205,000.00
17311-07-2020950.0010-07-20205,000.00
17411-07-202021,790.0011-07-20205,000.00
17511-07-202025,000.0013-07-20205,000.00
17611-07-20203,000.0014-07-20205,000.00
17713-07-20203,150.0016-07-20205,000.00
17813-07-20203,565.0022-07-20205,000.00
17913-07-20201.0023-07-20205,000.00
18013-07-20201,400.0026-07-20205,000.00
18113-07-20202,080.0004-07-20205,003.00
18213-07-2020475.0013-07-20205,196.00
18313-07-20204,905.0025-07-20205,408.00
18413-07-20205,196.0008-07-20205,439.00
18513-07-2020118.0009-07-20205,630.00
18613-07-20203,559.0014-07-20205,705.00
18713-07-20205,000.0029-07-20205,810.00
18813-07-20202,370.0014-07-20206,000.00
18913-07-20203,000.0010-07-20206,012.00
19013-07-202025,000.0004-07-20206,090.00
19113-07-20201,350.0027-07-20206,290.00
19213-07-202030,000.0003-07-20206,468.00
19313-07-202020,751.0027-07-20206,539.00
19413-07-202045,000.0003-07-20206,750.00
19513-07-202077.0025-07-20206,776.00
19613-07-202030,713.0007-07-20206,784.00
19714-07-20208,250.0028-07-20206,881.00
19814-07-20201,000.0003-07-20207,000.00
19914-07-20205.0007-07-20207,045.00
20014-07-2020520.0029-07-20207,045.00
20114-07-2020520.0003-07-20207,210.00
20214-07-20206,000.0004-07-20207,603.00
20314-07-20201,800.0001-07-20207,632.00
20414-07-202014,984.0006-07-20208,000.00
20514-07-202038,946.0009-07-20208,052.00
20614-07-20202,625.0014-07-20208,250.00
20714-07-2020602.4018-07-20208,379.00
20814-07-202014,000.0026-07-20208,567.00
20914-07-202020,000.0023-07-20208,670.00
21014-07-202020,000.0028-07-20208,773.00
21114-07-202050,000.0022-07-20208,940.00
21214-07-202018,295.0010-07-20209,125.00
21314-07-20205,000.0010-07-20209,996.00
21414-07-20205,705.0003-07-202010,000.00
21514-07-20201,500.0003-07-202010,000.00
21614-07-20201.0004-07-202010,000.00
21715-07-2020695.0004-07-202010,000.00
21815-07-20201,965.0009-07-202010,000.00
21915-07-20202,680.0010-07-202010,000.00
22015-07-2020520.0017-07-202010,000.00
22115-07-2020118.0025-07-202010,000.00
22215-07-202027,000.0027-07-202010,000.00
22316-07-20202,299.0017-07-202010,060.00
22416-07-202020,000.0017-07-202010,375.00
22516-07-20205,000.0022-07-202010,395.00
22616-07-20203,000.0017-07-202010,475.00
22716-07-202050,000.0010-07-202010,785.00
22816-07-202024,675.0007-07-202010,790.00
22916-07-202020,246.0007-07-202010,840.00
23017-07-20201,350.0002-07-202011,235.00
23117-07-20204,707.0001-07-202011,326.00
23217-07-202010,375.0001-07-202011,365.00
23317-07-202010,060.0021-07-202011,561.00
23417-07-202036,250.0030-07-202011,814.00
23517-07-202016,500.0027-07-202012,000.00
23617-07-202030,000.0028-07-202012,000.00
23717-07-202013,440.0029-07-202012,021.00
23817-07-202010,475.0007-07-202012,125.00
23917-07-20201,00,000.0002-07-202012,155.00
24017-07-202010,000.0002-07-202012,155.00
24117-07-202020,000.0001-07-202012,200.00
24218-07-20203,000.0029-07-202012,348.00
24318-07-202015,000.0021-07-202012,397.00
24418-07-202018,620.0025-07-202012,405.00
24518-07-20208,379.0008-07-202012,591.00
24618-07-202015,000.0003-07-202012,600.00
24720-07-202022,869.0031-07-202012,600.00
24820-07-20202,000.0022-07-202013,218.00
24920-07-20201,369.0003-07-202013,400.00
25021-07-2020118.0017-07-202013,440.00
25121-07-202012,397.0001-07-202013,600.00
25221-07-202038,530.0001-07-202013,600.00
25321-07-202035,295.0001-07-202013,600.00
25421-07-202075,000.0014-07-202014,000.00
25521-07-202050,000.0004-07-202014,375.00
25621-07-202011,561.0002-07-202014,400.00
25721-07-202020,000.0008-07-202014,700.00
25821-07-202051,818.0031-07-202014,806.00
25921-07-20203,500.0014-07-202014,984.00
26021-07-202024,000.0002-07-202015,000.00
26121-07-202030,982.0003-07-202015,000.00
26221-07-2020600.0004-07-202015,000.00
26322-07-20203,676.0007-07-202015,000.00
26422-07-20208,940.0018-07-202015,000.00
26522-07-20201,550.0018-07-202015,000.00
26622-07-202013,218.0024-07-202015,000.00
26722-07-20201,511.0029-07-202015,000.00
26822-07-20205,000.0007-07-202015,120.00
26922-07-20201,500.0025-07-202015,444.00
27022-07-202010,395.0002-07-202016,000.00
27122-07-202020,000.0017-07-202016,500.00
27223-07-20201,850.0002-07-202016,829.00
27323-07-2020118.0014-07-202018,295.00
27423-07-2020118.0024-07-202018,308.00
27523-07-20205,000.0018-07-202018,620.00
27623-07-202025,000.0024-07-202019,685.00
27723-07-202024,409.0002-07-202020,000.00
27823-07-202030,000.0003-07-202020,000.00
27923-07-202027,000.0004-07-202020,000.00
28023-07-2020709.0006-07-202020,000.00
28123-07-202031,484.0007-07-202020,000.00
28223-07-20204,438.0010-07-202020,000.00
28323-07-202025,390.0014-07-202020,000.00
28423-07-20208,670.0014-07-202020,000.00
28523-07-20201,280.0016-07-202020,000.00
28624-07-20203,585.0017-07-202020,000.00
28724-07-2020300.0021-07-202020,000.00
28824-07-20202,000.0022-07-202020,000.00
28924-07-20203,341.0024-07-202020,000.00
29024-07-20203,213.0029-07-202020,000.00
29124-07-202015,000.0031-07-202020,000.00
29224-07-202019,685.0007-07-202020,019.00
29324-07-20202,930.0010-07-202020,139.00
29424-07-2020986.0016-07-202020,246.00
29524-07-202018,308.0013-07-202020,751.00
29624-07-202020,000.0008-07-202020,999.00
29724-07-202051,049.0008-07-202021,000.00
29824-07-20204,000.0011-07-202021,790.00
29924-07-20204,775.0007-07-202022,680.00
30024-07-2020910.0002-07-202022,705.00
30125-07-20203,050.0020-07-202022,869.00
30225-07-202015,444.0004-07-202023,400.00
30325-07-20205,408.0027-07-202023,650.00
30425-07-202025,000.0021-07-202024,000.00
30525-07-2020360.0007-07-202024,329.00
30625-07-202010,000.0023-07-202024,409.00
30725-07-20206,776.0006-07-202024,570.00
30825-07-20201,400.0016-07-202024,675.00
30925-07-20202,568.0007-07-202024,680.00
31025-07-20202,500.0003-07-202025,000.00
31125-07-20203,000.0010-07-202025,000.00
31225-07-202012,405.0011-07-202025,000.00
31326-07-20208,567.0013-07-202025,000.00
31426-07-2020960.0023-07-202025,000.00
31526-07-20205,000.0025-07-202025,000.00
31627-07-2020500.0029-07-202025,000.00
31727-07-202023,650.0030-07-202025,000.00
31827-07-2020680.0004-07-202025,305.00
31927-07-2020435.0023-07-202025,390.00
32027-07-20204,835.0015-07-202027,000.00
32127-07-20201,781.0023-07-202027,000.00
32227-07-202075,000.0010-07-202028,686.00
32327-07-202010,000.0006-07-202028,804.00
32427-07-20203,000.0006-07-202028,810.00
32527-07-202040,431.0028-07-202029,816.00
32627-07-20201,00,000.0002-07-202030,000.00
32727-07-202045,570.0003-07-202030,000.00
32827-07-202012,000.0003-07-202030,000.00
32927-07-202030,000.0006-07-202030,000.00
33027-07-20206,290.0013-07-202030,000.00
33127-07-20206,539.0017-07-202030,000.00
33228-07-2020250.0023-07-202030,000.00
33328-07-20202,100.0027-07-202030,000.00
33428-07-20202,680.0031-07-202030,000.00
33528-07-20208,773.0029-07-202030,240.00
33628-07-202029,816.0013-07-202030,713.00
33728-07-20201,130.0021-07-202030,982.00
33828-07-20203,748.0010-07-202031,040.00
33928-07-20206,881.0023-07-202031,484.00
34028-07-20203,707.0003-07-202031,581.00
34128-07-202038,530.0010-07-202033,606.00
34228-07-202050,000.0003-07-202035,000.00
34328-07-202012,000.0030-07-202035,000.00
34428-07-202060,642.0021-07-202035,295.00
34528-07-20201,13,976.0017-07-202036,250.00
34628-07-202078,000.0003-07-202036,470.00
34729-07-20203,710.0010-07-202038,313.00
34829-07-202025,000.0021-07-202038,530.00
34929-07-2020380.0028-07-202038,530.00
35029-07-20202,080.0014-07-202038,946.00
35129-07-202012,021.0006-07-202040,000.00
35229-07-20204,500.0008-07-202040,000.00
35329-07-202015,000.0027-07-202040,431.00
35429-07-20201,540.0004-07-202042,000.00
35529-07-2020517.0030-07-202044,053.00
35629-07-20205,810.0013-07-202045,000.00
35729-07-20202,488.0029-07-202045,000.00
35829-07-202045,000.0029-07-202045,000.00
35929-07-202020,000.0027-07-202045,570.00
36029-07-20207,045.0029-07-202049,000.00
36129-07-202030,240.0001-07-202050,000.00
36229-07-202049,000.0006-07-202050,000.00
36329-07-202045,000.0009-07-202050,000.00
36429-07-2020200.0009-07-202050,000.00
36529-07-202012,348.0010-07-202050,000.00
36630-07-20202,270.0014-07-202050,000.00
36730-07-2020665.0016-07-202050,000.00
36830-07-20201,210.0021-07-202050,000.00
36930-07-20202,165.0028-07-202050,000.00
37030-07-202035,000.0009-07-202050,072.00
37130-07-20203,860.0024-07-202051,049.00
37230-07-20201,786.0021-07-202051,818.00
37330-07-2020700.0003-07-202052,000.00
37430-07-202025,000.0006-07-202054,280.00
37530-07-202044,053.0004-07-202060,000.00
37630-07-202011,814.0028-07-202060,642.00
37730-07-20201,800.0001-07-202065,000.00
37830-07-202090,000.0004-07-202068,009.00
37930-07-20201,600.0004-07-202073,577.00
38030-07-2020390.0021-07-202075,000.00
38131-07-20203,000.0027-07-202075,000.00
38231-07-20202,800.0028-07-202078,000.00
38331-07-20201,500.0007-07-202081,024.00
38431-07-202014,806.0030-07-202090,000.00
38531-07-20201,240.0031-07-202090,494.00
38631-07-2020500.0002-07-202091,445.00
38731-07-202012,600.0017-07-20201,00,000.00
38831-07-202030,000.0027-07-20201,00,000.00
38931-07-202020,000.0028-07-20201,13,976.00
39031-07-202090,494.0004-07-20201,22,500.00
Query
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Select columns B and C, go to Conditional Formatting, choose the "Use a formula to determine which cells to format" option, and enter this formula:
Excel Formula:
=COUNTIFS($B:$B,$B1,$C:$C,$C1)>1
then select your desired formatting color.
 
Upvote 0
Solution
I am trying to format the color of cells using confitional formatting. If on a particular date, in the total column, there are same amounts then it should color the cell. I tried sorting the data by total, that way it would be easier to find out if the common amounts have the same date. But was not able to solve it. Is there a way to apply conditional formatting to this.?


MrEXcel Query2.xlsx
BCDEF
1DateTotalDateTotal
201-07-202013,600.0001-07-20201.00
301-07-202013,600.0006-07-20201.00
401-07-202013,600.0013-07-20201.00
501-07-20201.0014-07-20201.00
601-07-20207,632.0014-07-20205.00
701-07-202012,200.0002-07-20206.00
801-07-2020730.0002-07-202013.04
901-07-202011,365.0009-07-202029.50
1001-07-202065,000.0006-07-202036.00
1101-07-20203,000.0013-07-202077.00
1201-07-202050,000.0002-07-2020100.00
1301-07-202011,326.0004-07-2020100.00
1402-07-202012,155.0003-07-2020104.96
1502-07-202012,155.0006-07-2020118.00
1602-07-20202,000.0007-07-2020118.00
1702-07-20203,694.0010-07-2020118.00
1802-07-2020100.0013-07-2020118.00
1902-07-20203,350.0015-07-2020118.00
2002-07-20206.0021-07-2020118.00
2102-07-202014,400.0023-07-2020118.00
2202-07-202013.0423-07-2020118.00
2302-07-202022,705.0007-07-2020140.00
2402-07-202091,445.0010-07-2020140.00
2502-07-202015,000.0029-07-2020200.00
2602-07-202011,235.0003-07-2020236.00
2702-07-202020,000.0028-07-2020250.00
2802-07-202016,829.0008-07-2020300.00
2902-07-202030,000.0024-07-2020300.00
3002-07-202016,000.0025-07-2020360.00
3103-07-20206,750.0009-07-2020380.00
3203-07-2020236.0029-07-2020380.00
3303-07-20201,100.0030-07-2020390.00
3403-07-20205,000.0027-07-2020435.00
3503-07-20206,468.0003-07-2020450.00
3603-07-20201,790.0013-07-2020475.00
3703-07-202036,470.0027-07-2020500.00
3803-07-20207,000.0031-07-2020500.00
3903-07-2020450.0029-07-2020517.00
4003-07-202010,000.0014-07-2020520.00
4103-07-20201,800.0014-07-2020520.00
4203-07-2020900.0015-07-2020520.00
4303-07-20207,210.0006-07-2020600.00
4403-07-2020104.9621-07-2020600.00
4503-07-202030,000.0014-07-2020602.40
4603-07-202015,000.0030-07-2020665.00
4703-07-202025,000.0009-07-2020680.00
4803-07-202030,000.0027-07-2020680.00
4903-07-20205,000.0015-07-2020695.00
5003-07-202012,600.0030-07-2020700.00
5103-07-202035,000.0023-07-2020709.00
5203-07-202020,000.0001-07-2020730.00
5303-07-202052,000.0004-07-2020750.00
5403-07-202010,000.0006-07-2020750.00
5503-07-202013,400.0009-07-2020825.00
5603-07-20203,000.0009-07-2020851.00
5703-07-20203,000.0004-07-2020862.00
5803-07-202031,581.0003-07-2020900.00
5904-07-20207,603.0008-07-2020900.00
6004-07-20205,003.0024-07-2020910.00
6104-07-2020100.0011-07-2020950.00
6204-07-20202,900.0026-07-2020960.00
6304-07-20201,22,500.0024-07-2020986.00
6404-07-20206,090.0009-07-2020990.00
6504-07-202010,000.0008-07-20201,000.00
6604-07-202014,375.0009-07-20201,000.00
6704-07-20202,090.0009-07-20201,000.00
6804-07-2020862.0014-07-20201,000.00
6904-07-20202,681.0003-07-20201,100.00
7004-07-20203,000.0028-07-20201,130.00
7104-07-202010,000.0006-07-20201,180.00
7204-07-202025,305.0030-07-20201,210.00
7304-07-202020,000.0005-07-20201,210.96
7404-07-202015,000.0031-07-20201,240.00
7504-07-202060,000.0023-07-20201,280.00
7604-07-202042,000.0006-07-20201,300.00
7704-07-202073,577.0013-07-20201,350.00
7804-07-2020750.0017-07-20201,350.00
7904-07-202068,009.0020-07-20201,369.00
8004-07-20204,494.0013-07-20201,400.00
8104-07-202023,400.0025-07-20201,400.00
8204-07-20202,000.0006-07-20201,500.00
8305-07-20201,210.9606-07-20201,500.00
8406-07-202036.0007-07-20201,500.00
8506-07-20201,300.0014-07-20201,500.00
8606-07-20202,208.0022-07-20201,500.00
8706-07-202028,810.0031-07-20201,500.00
8806-07-202020,000.0022-07-20201,511.00
8906-07-20201.0029-07-20201,540.00
9006-07-2020600.0022-07-20201,550.00
9106-07-202028,804.0011-07-20201,600.00
9206-07-2020750.0030-07-20201,600.00
9306-07-20201,180.0027-07-20201,781.00
9406-07-2020118.0030-07-20201,786.00
9506-07-20202,660.0003-07-20201,790.00
9606-07-20208,000.0003-07-20201,800.00
9706-07-202040,000.0014-07-20201,800.00
9806-07-202024,570.0030-07-20201,800.00
9906-07-20201,500.0023-07-20201,850.00
10006-07-202050,000.0015-07-20201,965.00
10106-07-20201,500.0002-07-20202,000.00
10206-07-202054,280.0004-07-20202,000.00
10306-07-202030,000.0020-07-20202,000.00
10407-07-20207,045.0024-07-20202,000.00
10507-07-202012,125.0010-07-20202,025.00
10607-07-20201,500.0013-07-20202,080.00
10707-07-20206,784.0029-07-20202,080.00
10807-07-2020118.0004-07-20202,090.00
10907-07-2020140.0028-07-20202,100.00
11007-07-202015,000.0010-07-20202,120.00
11107-07-202020,019.0010-07-20202,123.00
11207-07-202010,840.0030-07-20202,165.00
11307-07-202010,790.0006-07-20202,208.00
11407-07-202024,329.0030-07-20202,270.00
11507-07-202024,680.0016-07-20202,299.00
11607-07-20202,950.0011-07-20202,331.00
11707-07-202022,680.0013-07-20202,370.00
11807-07-202020,000.0029-07-20202,488.00
11907-07-20202,500.0007-07-20202,500.00
12007-07-202081,024.0025-07-20202,500.00
12107-07-202015,120.0025-07-20202,568.00
12208-07-20205,000.0014-07-20202,625.00
12308-07-20201,000.0006-07-20202,660.00
12408-07-2020900.0015-07-20202,680.00
12508-07-202012,591.0028-07-20202,680.00
12608-07-202020,999.0004-07-20202,681.00
12708-07-202040,000.0031-07-20202,800.00
12808-07-20205,439.0004-07-20202,900.00
12908-07-202021,000.0024-07-20202,930.00
13008-07-2020300.0007-07-20202,950.00
13108-07-202014,700.0001-07-20203,000.00
13209-07-2020380.0003-07-20203,000.00
13309-07-202010,000.0003-07-20203,000.00
13409-07-20204,920.0004-07-20203,000.00
13509-07-20208,052.0010-07-20203,000.00
13609-07-2020990.0011-07-20203,000.00
13709-07-2020851.0011-07-20203,000.00
13809-07-2020825.0013-07-20203,000.00
13909-07-2020680.0016-07-20203,000.00
14009-07-20201,000.0018-07-20203,000.00
14109-07-202050,000.0025-07-20203,000.00
14209-07-20201,000.0027-07-20203,000.00
14309-07-20205,630.0031-07-20203,000.00
14409-07-202029.5025-07-20203,050.00
14509-07-20205,000.0013-07-20203,150.00
14609-07-202050,000.0024-07-20203,213.00
14709-07-202050,072.0024-07-20203,341.00
14810-07-202033,606.0002-07-20203,350.00
14910-07-20202,120.0021-07-20203,500.00
15010-07-202038,313.0013-07-20203,559.00
15110-07-202025,000.0010-07-20203,565.00
15210-07-202020,000.0013-07-20203,565.00
15310-07-20203,000.0024-07-20203,585.00
15410-07-20205,000.0022-07-20203,676.00
15510-07-202020,139.0002-07-20203,694.00
15610-07-202031,040.0028-07-20203,707.00
15710-07-20202,025.0029-07-20203,710.00
15810-07-202050,000.0028-07-20203,748.00
15910-07-202010,000.0030-07-20203,860.00
16010-07-202010,785.0024-07-20204,000.00
16110-07-202028,686.0023-07-20204,438.00
16210-07-20206,012.0004-07-20204,494.00
16310-07-20202,123.0029-07-20204,500.00
16410-07-20209,996.0017-07-20204,707.00
16510-07-20203,565.0024-07-20204,775.00
16610-07-2020118.0027-07-20204,835.00
16710-07-20209,125.0013-07-20204,905.00
16810-07-2020140.0009-07-20204,920.00
16911-07-20202,331.0003-07-20205,000.00
17011-07-20203,000.0003-07-20205,000.00
17111-07-20201,600.0008-07-20205,000.00
17211-07-20205,000.0009-07-20205,000.00
17311-07-2020950.0010-07-20205,000.00
17411-07-202021,790.0011-07-20205,000.00
17511-07-202025,000.0013-07-20205,000.00
17611-07-20203,000.0014-07-20205,000.00
17713-07-20203,150.0016-07-20205,000.00
17813-07-20203,565.0022-07-20205,000.00
17913-07-20201.0023-07-20205,000.00
18013-07-20201,400.0026-07-20205,000.00
18113-07-20202,080.0004-07-20205,003.00
18213-07-2020475.0013-07-20205,196.00
18313-07-20204,905.0025-07-20205,408.00
18413-07-20205,196.0008-07-20205,439.00
18513-07-2020118.0009-07-20205,630.00
18613-07-20203,559.0014-07-20205,705.00
18713-07-20205,000.0029-07-20205,810.00
18813-07-20202,370.0014-07-20206,000.00
18913-07-20203,000.0010-07-20206,012.00
19013-07-202025,000.0004-07-20206,090.00
19113-07-20201,350.0027-07-20206,290.00
19213-07-202030,000.0003-07-20206,468.00
19313-07-202020,751.0027-07-20206,539.00
19413-07-202045,000.0003-07-20206,750.00
19513-07-202077.0025-07-20206,776.00
19613-07-202030,713.0007-07-20206,784.00
19714-07-20208,250.0028-07-20206,881.00
19814-07-20201,000.0003-07-20207,000.00
19914-07-20205.0007-07-20207,045.00
20014-07-2020520.0029-07-20207,045.00
20114-07-2020520.0003-07-20207,210.00
20214-07-20206,000.0004-07-20207,603.00
20314-07-20201,800.0001-07-20207,632.00
20414-07-202014,984.0006-07-20208,000.00
20514-07-202038,946.0009-07-20208,052.00
20614-07-20202,625.0014-07-20208,250.00
20714-07-2020602.4018-07-20208,379.00
20814-07-202014,000.0026-07-20208,567.00
20914-07-202020,000.0023-07-20208,670.00
21014-07-202020,000.0028-07-20208,773.00
21114-07-202050,000.0022-07-20208,940.00
21214-07-202018,295.0010-07-20209,125.00
21314-07-20205,000.0010-07-20209,996.00
21414-07-20205,705.0003-07-202010,000.00
21514-07-20201,500.0003-07-202010,000.00
21614-07-20201.0004-07-202010,000.00
21715-07-2020695.0004-07-202010,000.00
21815-07-20201,965.0009-07-202010,000.00
21915-07-20202,680.0010-07-202010,000.00
22015-07-2020520.0017-07-202010,000.00
22115-07-2020118.0025-07-202010,000.00
22215-07-202027,000.0027-07-202010,000.00
22316-07-20202,299.0017-07-202010,060.00
22416-07-202020,000.0017-07-202010,375.00
22516-07-20205,000.0022-07-202010,395.00
22616-07-20203,000.0017-07-202010,475.00
22716-07-202050,000.0010-07-202010,785.00
22816-07-202024,675.0007-07-202010,790.00
22916-07-202020,246.0007-07-202010,840.00
23017-07-20201,350.0002-07-202011,235.00
23117-07-20204,707.0001-07-202011,326.00
23217-07-202010,375.0001-07-202011,365.00
23317-07-202010,060.0021-07-202011,561.00
23417-07-202036,250.0030-07-202011,814.00
23517-07-202016,500.0027-07-202012,000.00
23617-07-202030,000.0028-07-202012,000.00
23717-07-202013,440.0029-07-202012,021.00
23817-07-202010,475.0007-07-202012,125.00
23917-07-20201,00,000.0002-07-202012,155.00
24017-07-202010,000.0002-07-202012,155.00
24117-07-202020,000.0001-07-202012,200.00
24218-07-20203,000.0029-07-202012,348.00
24318-07-202015,000.0021-07-202012,397.00
24418-07-202018,620.0025-07-202012,405.00
24518-07-20208,379.0008-07-202012,591.00
24618-07-202015,000.0003-07-202012,600.00
24720-07-202022,869.0031-07-202012,600.00
24820-07-20202,000.0022-07-202013,218.00
24920-07-20201,369.0003-07-202013,400.00
25021-07-2020118.0017-07-202013,440.00
25121-07-202012,397.0001-07-202013,600.00
25221-07-202038,530.0001-07-202013,600.00
25321-07-202035,295.0001-07-202013,600.00
25421-07-202075,000.0014-07-202014,000.00
25521-07-202050,000.0004-07-202014,375.00
25621-07-202011,561.0002-07-202014,400.00
25721-07-202020,000.0008-07-202014,700.00
25821-07-202051,818.0031-07-202014,806.00
25921-07-20203,500.0014-07-202014,984.00
26021-07-202024,000.0002-07-202015,000.00
26121-07-202030,982.0003-07-202015,000.00
26221-07-2020600.0004-07-202015,000.00
26322-07-20203,676.0007-07-202015,000.00
26422-07-20208,940.0018-07-202015,000.00
26522-07-20201,550.0018-07-202015,000.00
26622-07-202013,218.0024-07-202015,000.00
26722-07-20201,511.0029-07-202015,000.00
26822-07-20205,000.0007-07-202015,120.00
26922-07-20201,500.0025-07-202015,444.00
27022-07-202010,395.0002-07-202016,000.00
27122-07-202020,000.0017-07-202016,500.00
27223-07-20201,850.0002-07-202016,829.00
27323-07-2020118.0014-07-202018,295.00
27423-07-2020118.0024-07-202018,308.00
27523-07-20205,000.0018-07-202018,620.00
27623-07-202025,000.0024-07-202019,685.00
27723-07-202024,409.0002-07-202020,000.00
27823-07-202030,000.0003-07-202020,000.00
27923-07-202027,000.0004-07-202020,000.00
28023-07-2020709.0006-07-202020,000.00
28123-07-202031,484.0007-07-202020,000.00
28223-07-20204,438.0010-07-202020,000.00
28323-07-202025,390.0014-07-202020,000.00
28423-07-20208,670.0014-07-202020,000.00
28523-07-20201,280.0016-07-202020,000.00
28624-07-20203,585.0017-07-202020,000.00
28724-07-2020300.0021-07-202020,000.00
28824-07-20202,000.0022-07-202020,000.00
28924-07-20203,341.0024-07-202020,000.00
29024-07-20203,213.0029-07-202020,000.00
29124-07-202015,000.0031-07-202020,000.00
29224-07-202019,685.0007-07-202020,019.00
29324-07-20202,930.0010-07-202020,139.00
29424-07-2020986.0016-07-202020,246.00
29524-07-202018,308.0013-07-202020,751.00
29624-07-202020,000.0008-07-202020,999.00
29724-07-202051,049.0008-07-202021,000.00
29824-07-20204,000.0011-07-202021,790.00
29924-07-20204,775.0007-07-202022,680.00
30024-07-2020910.0002-07-202022,705.00
30125-07-20203,050.0020-07-202022,869.00
30225-07-202015,444.0004-07-202023,400.00
30325-07-20205,408.0027-07-202023,650.00
30425-07-202025,000.0021-07-202024,000.00
30525-07-2020360.0007-07-202024,329.00
30625-07-202010,000.0023-07-202024,409.00
30725-07-20206,776.0006-07-202024,570.00
30825-07-20201,400.0016-07-202024,675.00
30925-07-20202,568.0007-07-202024,680.00
31025-07-20202,500.0003-07-202025,000.00
31125-07-20203,000.0010-07-202025,000.00
31225-07-202012,405.0011-07-202025,000.00
31326-07-20208,567.0013-07-202025,000.00
31426-07-2020960.0023-07-202025,000.00
31526-07-20205,000.0025-07-202025,000.00
31627-07-2020500.0029-07-202025,000.00
31727-07-202023,650.0030-07-202025,000.00
31827-07-2020680.0004-07-202025,305.00
31927-07-2020435.0023-07-202025,390.00
32027-07-20204,835.0015-07-202027,000.00
32127-07-20201,781.0023-07-202027,000.00
32227-07-202075,000.0010-07-202028,686.00
32327-07-202010,000.0006-07-202028,804.00
32427-07-20203,000.0006-07-202028,810.00
32527-07-202040,431.0028-07-202029,816.00
32627-07-20201,00,000.0002-07-202030,000.00
32727-07-202045,570.0003-07-202030,000.00
32827-07-202012,000.0003-07-202030,000.00
32927-07-202030,000.0006-07-202030,000.00
33027-07-20206,290.0013-07-202030,000.00
33127-07-20206,539.0017-07-202030,000.00
33228-07-2020250.0023-07-202030,000.00
33328-07-20202,100.0027-07-202030,000.00
33428-07-20202,680.0031-07-202030,000.00
33528-07-20208,773.0029-07-202030,240.00
33628-07-202029,816.0013-07-202030,713.00
33728-07-20201,130.0021-07-202030,982.00
33828-07-20203,748.0010-07-202031,040.00
33928-07-20206,881.0023-07-202031,484.00
34028-07-20203,707.0003-07-202031,581.00
34128-07-202038,530.0010-07-202033,606.00
34228-07-202050,000.0003-07-202035,000.00
34328-07-202012,000.0030-07-202035,000.00
34428-07-202060,642.0021-07-202035,295.00
34528-07-20201,13,976.0017-07-202036,250.00
34628-07-202078,000.0003-07-202036,470.00
34729-07-20203,710.0010-07-202038,313.00
34829-07-202025,000.0021-07-202038,530.00
34929-07-2020380.0028-07-202038,530.00
35029-07-20202,080.0014-07-202038,946.00
35129-07-202012,021.0006-07-202040,000.00
35229-07-20204,500.0008-07-202040,000.00
35329-07-202015,000.0027-07-202040,431.00
35429-07-20201,540.0004-07-202042,000.00
35529-07-2020517.0030-07-202044,053.00
35629-07-20205,810.0013-07-202045,000.00
35729-07-20202,488.0029-07-202045,000.00
35829-07-202045,000.0029-07-202045,000.00
35929-07-202020,000.0027-07-202045,570.00
36029-07-20207,045.0029-07-202049,000.00
36129-07-202030,240.0001-07-202050,000.00
36229-07-202049,000.0006-07-202050,000.00
36329-07-202045,000.0009-07-202050,000.00
36429-07-2020200.0009-07-202050,000.00
36529-07-202012,348.0010-07-202050,000.00
36630-07-20202,270.0014-07-202050,000.00
36730-07-2020665.0016-07-202050,000.00
36830-07-20201,210.0021-07-202050,000.00
36930-07-20202,165.0028-07-202050,000.00
37030-07-202035,000.0009-07-202050,072.00
37130-07-20203,860.0024-07-202051,049.00
37230-07-20201,786.0021-07-202051,818.00
37330-07-2020700.0003-07-202052,000.00
37430-07-202025,000.0006-07-202054,280.00
37530-07-202044,053.0004-07-202060,000.00
37630-07-202011,814.0028-07-202060,642.00
37730-07-20201,800.0001-07-202065,000.00
37830-07-202090,000.0004-07-202068,009.00
37930-07-20201,600.0004-07-202073,577.00
38030-07-2020390.0021-07-202075,000.00
38131-07-20203,000.0027-07-202075,000.00
38231-07-20202,800.0028-07-202078,000.00
38331-07-20201,500.0007-07-202081,024.00
38431-07-202014,806.0030-07-202090,000.00
38531-07-20201,240.0031-07-202090,494.00
38631-07-2020500.0002-07-202091,445.00
38731-07-202012,600.0017-07-20201,00,000.00
38831-07-202030,000.0027-07-20201,00,000.00
38931-07-202020,000.0028-07-20201,13,976.00
39031-07-202090,494.0004-07-20201,22,500.00
Query
Got it.
=COUNTIFS($B:$B,$B1,$C:$C,$C1)>1
Got. Thanks
Select columns B and C, go to Conditional Formatting, choose the "Use a formula to determine which cells to format" option, and enter this formula:
Excel Formula:
=COUNTIFS($B:$B,$B1,$C:$C,$C1)>1
then select your desired formatting color.

Select columns B and C, go to Conditional Formatting, choose the "Use a formula to determine which cells to format" option, and enter this formula:
Excel Formula:
=COUNTIFS($B:$B,$B1,$C:$C,$C1)>1
then select your desired formatting color.
Thanks Joe.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,207
Members
452,618
Latest member
Tam84

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