Spreadsheet: 868461d1715188641-copying-conditionnal-format-the-right-way-exemple-ec-for-excelforum
Sheet: Feuil1

Title |  |  |  |  |  |  |  |  |  |  |  | Title
A | B | C | D | E | F | G |  |  |  |  |  | A | B | C | D | E | F | G
162 | 185 | 164 | 179 | 171 | 160 | 171 |  |  |  |  |  | 162 | 185 | 164 | 179 | 171 | 160 | 171
189 | 213 | 191 | 208 | 194 | 186 | 200 |  | [NAME] |  | Bad exemple |  | 189 | 213 | 191 | 208 | 194 | 186 | 200
216 | 239 | 218 | 236 | 220 | 212 | 229 |  | <<<<< |  | >>>>> |  | 216 | 239 | 218 | 236 | 220 | 212 | 229
240 | 265 | 244 | 264 | 247 | 237 | 256 |  |  |  |  |  | 240 | 265 | 244 | 264 | 247 | 237 | 256
267 | 293 | 271 | 293 | 270 | 263 | 285 |  |  |  |  |  | 267 | 293 | 271 | 293 | 270 | 263 | 285
294 | 321 | 298 | 322 | 296 | 289 | 314 |  |  |  |  |  | 294 | 321 | 298 | 322 | 296 | 289 | 314
318 | 348 | 324 | 350 | 321 | 315 | 342 |  |  |  |  |  | 318 | 348 | 324 | 350 | 321 | 315 | 342
345 | 375 | 350 | 379 | 345 | 340 | 370 |  |  |  |  |  | 345 | 375 | 350 | 379 | 345 | 340 | 370
369 | 402 | 376 | 407 | 370 | 366 | 398 |  |  |  |  |  | 369 | 402 | 376 | 407 | 370 | 366 | 398
396 | 430 | 403 | 436 | 396 | 392 | 427 |  |  |  |  |  | 396 | 430 | 403 | 436 | 396 | 392 | 427
419 | 459 | 425 | 466 | 417 | 414 | 454 |  |  |  |  |  | 419 | 459 | 425 | 466 | 417 | 414 | 454
441 | 488 | 447 | 496 | 442 | 435 | 480 |  |  |  |  |  | 441 | 488 | 447 | 496 | 442 | 435 | 480
464 | 518 | 473 | 528 | 464 | 456 | 508 |  |  |  |  |  | 464 | 518 | 473 | 528 | 464 | 456 | 508
487 | 547 | 495 | 558 | 485 | 478 | 535 |  |  |  |  |  | 487 | 547 | 495 | 558 | 485 | 478 | 535
510 | 576 | 518 | 590 | 508 | 499 | 563 |  |  |  |  |  | 510 | 576 | 518 | 590 | 508 | 499 | 563
536 | 607 | 540 | 621 | 534 | 524 | 591 |  |  |  |  |  | 536 | 607 | 540 | 621 | 534 | 524 | 591
559 | 636 | 562 | 651 | 556 | 546 | 618 |  |  |  |  |  | 559 | 636 | 562 | 651 | 556 | 546 | 618
582 | 666 | 588 | 683 | 577 | 567 | 646 |  |  |  |  |  | 582 | 666 | 588 | 683 | 577 | 567 | 646
604 | 695 | 610 | 713 | 601 | 588 | 672 |  |  |  |  |  | 604 | 695 | 610 | 713 | 601 | 588 | 672
627 | 724 | 632 | 743 | 623 | 610 | 699 |  |  |  |  |  | 627 | 724 | 632 | 743 | 623 | 610 | 699
650 | 753 | 654 | 773 | 645 | 632 | 726 |  |  |  |  |  | 650 | 753 | 654 | 773 | 645 | 632 | 726
672 | 783 | 678 | 803 | 669 | 653 | 753 |  |  |  |  |  | 672 | 783 | 678 | 803 | 669 | 653 | 753
696 | 811 | 700 | 836 | 694 | 676 | 780 |  |  |  |  |  | 696 | 811 | 700 | 836 | 694 | 676 | 780
718 | 841 | 723 | 866 | 718 | 697 | 807 |  |  |  |  |  | 718 | 841 | 723 | 866 | 718 | 697 | 807
741 | 872 | 747 | 898 | 740 | 718 | 835 |  |  |  |  |  | 741 | 872 | 747 | 898 | 740 | 718 | 835
767 | 902 | 771 | 928 | 762 | 742 | 863 |  |  |  |  |  | 767 | 902 | 771 | 928 | 762 | 742 | 863
789 | 932 | 794 | 958 | 786 | 764 | 890 |  |  |  |  |  | 789 | 932 | 794 | 958 | 786 | 764 | 890
813 | 960 | 816 | 991 | 811 | 786 | 917 |  |  |  |  |  | 813 | 960 | 816 | 991 | 811 | 786 | 917
835 | 990 | 840 | 1021 | 835 | 806 | 944 |  |  |  |  |  | 835 | 990 | 840 | 1021 | 835 | 806 | 944
858 | 1019 | 862 | 1051 | 857 | 829 | 971 |  |  |  |  |  | 858 | 1019 | 862 | 1051 | 857 | 829 | 971
881 | 1048 | 884 | 1081 | 878 | 851 | 998 |  |  |  |  |  | 881 | 1048 | 884 | 1081 | 878 | 851 | 998
903 | 1077 | 907 | 1111 | 903 | 872 | 1024 |  |  |  |  |  | 903 | 1077 | 907 | 1111 | 903 | 872 | 1024
926 | 1108 | 932 | 1143 | 925 | 893 | 1052 |  |  |  |  |  | 926 | 1108 | 932 | 1143 | 925 | 893 | 1052
949 | 1137 | 955 | 1173 | 947 | 915 | 1079 |  |  |  |  |  | 949 | 1137 | 955 | 1173 | 947 | 915 | 1079
972 | 1165 | 978 | 1205 | 969 | 936 | 1107 |  |  |  |  |  | 972 | 1165 | 978 | 1205 | 969 | 936 | 1107
998 | 1196 | 1000 | 1236 | 995 | 961 | 1135 |  |  |  |  |  | 998 | 1196 | 1000 | 1236 | 995 | 961 | 1135
1021 | 1225 | 1023 | 1266 | 1018 | 983 | 1162 |  |  |  |  |  | 1021 | 1225 | 1023 | 1266 | 1018 | 983 | 1162
1044 | 1256 | 1048 | 1298 | 1039 | 1004 | 1190 |  |  |  |  |  | 1044 | 1256 | 1048 | 1298 | 1039 | 1004 | 1190
1066 | 1285 | 1071 | 1328 | 1063 | 1025 | 1216 |  |  |  |  |  | 1066 | 1285 | 1071 | 1328 | 1063 | 1025 | 1216
1089 | 1314 | 1093 | 1358 | 1085 | 1047 | 1243 |  |  |  |  |  | 1089 | 1314 | 1093 | 1358 | 1085 | 1047 | 1243
1108 | 1341 | 1110 | 1383 | 1113 | 1066 | 1269 |  |  |  |  |  | 1108 | 1341 | 1110 | 1383 | 1113 | 1066 | 1269
1130 | 1366 | 1130 | 1408 | 1140 | 1085 | 1296 |  |  |  |  |  | 1130 | 1366 | 1130 | 1408 | 1140 | 1085 | 1296
1148 | 1394 | 1151 | 1434 | 1170 | 1102 | 1323 |  |  |  |  |  | 1148 | 1394 | 1151 | 1434 | 1170 | 1102 | 1323
1171 | 1420 | 1169 | 1461 | 1199 | 1123 | 1350 |  |  |  |  |  | 1171 | 1420 | 1169 | 1461 | 1199 | 1123 | 1350
1190 | 1443 | 1187 | 1484 | 1226 | 1142 | 1375 |  |  |  |  |  | 1190 | 1443 | 1187 | 1484 | 1226 | 1142 | 1375
1208 | 1472 | 1205 | 1509 | 1253 | 1160 | 1403 |  |  |  |  |  | 1208 | 1472 | 1205 | 1509 | 1253 | 1160 | 1403
1230 | 1499 | 1223 | 1536 | 1282 | 1180 | 1430 |  |  |  |  |  | 1230 | 1499 | 1223 | 1536 | 1282 | 1180 | 1430
1249 | 1526 | 1244 | 1562 | 1312 | 1198 | 1457 |  |  |  |  |  | 1249 | 1526 | 1244 | 1562 | 1312 | 1198 | 1457
1272 | 1550 | 1264 | 1587 | 1339 | 1218 | 1484 |  |  |  |  |  | 1272 | 1550 | 1264 | 1587 | 1339 | 1218 | 1484
1290 | 1578 | 1281 | 1612 | 1367 | 1236 | 1510 |  |  |  |  |  | 1290 | 1578 | 1281 | 1612 | 1367 | 1236 | 1510
1309 | 1605 | 1298 | 1637 | 1395 | 1255 | 1536 |  |  |  |  |  | 1309 | 1605 | 1298 | 1637 | 1395 | 1255 | 1536
1331 | 1630 | 1318 | 1662 | 1422 | 1274 | 1563 |  |  |  |  |  | 1331 | 1630 | 1318 | 1662 | 1422 | 1274 | 1563
1349 | 1657 | 1339 | 1688 | 1452 | 1291 | 1590 |  |  |  |  |  | 1349 | 1657 | 1339 | 1688 | 1452 | 1291 | 1590
1369 | 1683 | 1357 | 1714 | 1478 | 1309 | 1615 |  |  |  |  |  | 1369 | 1683 | 1357 | 1714 | 1478 | 1309 | 1615
1391 | 1707 | 1375 | 1738 | 1507 | 1329 | 1642 |  |  |  |  |  | 1391 | 1707 | 1375 | 1738 | 1507 | 1329 | 1642
1409 | 1735 | 1393 | 1763 | 1535 | 1347 | 1670 |  |  |  |  |  | 1409 | 1735 | 1393 | 1763 | 1535 | 1347 | 1670
1428 | 1761 | 1411 | 1789 | 1561 | 1364 | 1695 |  |  |  |  |  | 1428 | 1761 | 1411 | 1789 | 1561 | 1364 | 1695
1447 | 1788 | 1432 | 1815 | 1591 | 1382 | 1722 |  |  |  |  |  | 1447 | 1788 | 1432 | 1815 | 1591 | 1382 | 1722
1470 | 1813 | 1452 | 1840 | 1618 | 1402 | 1749 |  |  |  |  |  | 1470 | 1813 | 1452 | 1840 | 1618 | 1402 | 1749
1488 | 1840 | 1469 | 1865 | 1646 | 1420 | 1775 |  |  |  |  |  | 1488 | 1840 | 1469 | 1865 | 1646 | 1420 | 1775
1509 | 1875 | 1496 | 1894 | 1680 | 1441 | 1795 |  |  |  |  |  | 1509 | 1875 | 1496 | 1894 | 1680 | 1441 | 1795
1531 | 1913 | 1521 | 1923 | 1714 | 1461 | 1816 |  |  |  |  |  | 1531 | 1913 | 1521 | 1923 | 1714 | 1461 | 1816
1554 | 1947 | 1546 | 1950 | 1748 | 1482 | 1834 |  |  |  |  |  | 1554 | 1947 | 1546 | 1950 | 1748 | 1482 | 1834
1573 | 1985 | 1572 | 1979 | 1782 | 1500 | 1853 |  |  |  |  |  | 1573 | 1985 | 1572 | 1979 | 1782 | 1500 | 1853
1594 | 2021 | 1599 | 2009 | 1816 | 1521 | 1874 |  |  |  |  |  | 1594 | 2021 | 1599 | 2009 | 1816 | 1521 | 1874
1618 | 2056 | 1624 | 2038 | 1850 | 1544 | 1895 |  |  |  |  |  | 1618 | 2056 | 1624 | 2038 | 1850 | 1544 | 1895
1640 | 2094 | 1649 | 2067 | 1884 | 1564 | 1915 |  |  |  |  |  | 1640 | 2094 | 1649 | 2067 | 1884 | 1564 | 1915
1660 | 2128 | 1675 | 2094 | 1918 | 1583 | 1932 |  |  |  |  |  | 1660 | 2128 | 1675 | 2094 | 1918 | 1583 | 1932
1679 | 2166 | 1701 | 2123 | 1952 | 1601 | 1952 |  |  |  |  |  | 1679 | 2166 | 1701 | 2123 | 1952 | 1601 | 1952
1703 | 2201 | 1727 | 2152 | 1986 | 1624 | 1973 |  |  |  |  |  | 1703 | 2201 | 1727 | 2152 | 1986 | 1624 | 1973
1723 | 2238 | 1752 | 2181 | 2020 | 1644 | 1992 |  |  |  |  |  | 1723 | 2238 | 1752 | 2181 | 2020 | 1644 | 1992
1746 | 2274 | 1779 | 2210 | 2054 | 1664 | 2013 |  |  |  |  |  | 1746 | 2274 | 1779 | 2210 | 2054 | 1664 | 2013
1768 | 2309 | 1804 | 2237 | 2088 | 1686 | 2032 |  |  |  |  |  | 1768 | 2309 | 1804 | 2237 | 2088 | 1686 | 2032
1788 | 2346 | 1830 | 2266 | 2122 | 1705 | 2051 |  |  |  |  |  | 1788 | 2346 | 1830 | 2266 | 2122 | 1705 | 2051
1808 | 2384 | 1855 | 2296 | 2156 | 1724 | 2070 |  |  |  |  |  | 1808 | 2384 | 1855 | 2296 | 2156 | 1724 | 2070
1832 | 2419 | 1881 | 2327 | 2191 | 1745 | 2092 |  |  |  |  |  | 1832 | 2419 | 1881 | 2327 | 2191 | 1745 | 2092
1855 | 2455 | 1908 | 2356 | 2225 | 1766 | 2113 |  |  |  |  |  | 1855 | 2455 | 1908 | 2356 | 2225 | 1766 | 2113
1874 | 2491 | 1932 | 2383 | 2259 | 1786 | 2130 |  |  |  |  |  | 1874 | 2491 | 1932 | 2383 | 2259 | 1786 | 2130
1894 | 2529 | 1958 | 2412 | 2293 | 1804 | 2149 |  |  |  |  |  | 1894 | 2529 | 1958 | 2412 | 2293 | 1804 | 2149
1917 | 2564 | 1984 | 2441 | 2327 | 1826 | 2170 |  |  |  |  |  | 1917 | 2564 | 1984 | 2441 | 2327 | 1826 | 2170
1941 | 2598 | 2009 | 2470 | 2361 | 1849 | 2190 |  |  |  |  |  | 1941 | 2598 | 2009 | 2470 | 2361 | 1849 | 2190
1960 | 2637 | 2036 | 2499 | 2395 | 1867 | 2211 |  |  |  |  |  | 1960 | 2637 | 2036 | 2499 | 2395 | 1867 | 2211
1983 | 2672 | 2061 | 2526 | 2429 | 1888 | 2230 |  |  |  |  |  | 1983 | 2672 | 2061 | 2526 | 2429 | 1888 | 2230
2002 | 2710 | 2087 | 2555 | 2463 | 1906 | 2249 |  |  |  |  |  | 2002 | 2710 | 2087 | 2555 | 2463 | 1906 | 2249
2026 | 2743 | 2112 | 2584 | 2495 | 1929 | 2269 |  |  |  |  |  | 2026 | 2743 | 2112 | 2584 | 2495 | 1929 | 2269
2050 | 2778 | 2137 | 2613 | 2528 | 1952 | 2290 |  |  |  |  |  | 2050 | 2778 | 2137 | 2613 | 2528 | 1952 | 2290
2069 | 2817 | 2164 | 2642 | 2562 | 1970 | 2310 |  |  |  |  |  | 2069 | 2817 | 2164 | 2642 | 2562 | 1970 | 2310
2092 | 2851 | 2188 | 2669 | 2596 | 1991 | 2328 |  |  |  |  |  | 2092 | 2851 | 2188 | 2669 | 2596 | 1991 | 2328
2111 | 2889 | 2214 | 2698 | 2630 | 2009 | 2348 |  |  |  |  |  | 2111 | 2889 | 2214 | 2698 | 2630 | 2009 | 2348
2135 | 2924 | 2240 | 2727 | 2664 | 2032 | 2369 |  |  |  |  |  | 2135 | 2924 | 2240 | 2727 | 2664 | 2032 | 2369
2159 | 2959 | 2267 | 2756 | 2698 | 2055 | 2390 |  |  |  |  |  | 2159 | 2959 | 2267 | 2756 | 2698 | 2055 | 2390
2178 | 2997 | 2292 | 2785 | 2732 | 2073 | 2410 |  |  |  |  |  | 2178 | 2997 | 2292 | 2785 | 2732 | 2073 | 2410
2201 | 3031 | 2318 | 2812 | 2766 | 2094 | 2428 |  |  |  |  |  | 2201 | 3031 | 2318 | 2812 | 2766 | 2094 | 2428
2221 | 3070 | 2344 | 2841 | 2800 | 2113 | 2448 |  |  |  |  |  | 2221 | 3070 | 2344 | 2841 | 2800 | 2113 | 2448
2244 | 3105 | 2369 | 2871 | 2834 | 2135 | 2469 |  |  |  |  |  | 2244 | 3105 | 2369 | 2871 | 2834 | 2135 | 2469
2264 | 3144 | 2395 | 2900 | 2868 | 2154 | 2489 |  |  |  |  |  | 2264 | 3144 | 2395 | 2900 | 2868 | 2154 | 2489
2287 | 3178 | 2421 | 2927 | 2902 | 2175 | 2507 |  |  |  |  |  | 2287 | 3178 | 2421 | 2927 | 2902 | 2175 | 2507
2306 | 3216 | 2446 | 2956 | 2936 | 2193 | 2527 |  |  |  |  |  | 2306 | 3216 | 2446 | 2956 | 2936 | 2193 | 2527
2330 | 3251 | 2473 | 2985 | 2970 | 2216 | 2548 |  |  |  |  |  | 2330 | 3251 | 2473 | 2985 | 2970 | 2216 | 2548