| 4 | Formatowanie warunkowe: | |
| 2 | Formatowane są wartości nienumeryczne | |
| Czerwony | ||
| 1J6 | ||
| 8/25/2022 3:43 | ||
| Tekst | ||
| 987 | ||
| 98f | ||
| 1 | 12 | 23 | 34 | Formatowanie warunkowe: | |
| 36 | 13 | 24 | 35 | Formatowane są komórki, których wartości są większe od średniej | |
| 3 | 14 | 25 | 2 | ||
| 4 | 15 | 26 | 37 | ||
| 5 | 16 | 27 | 38 | ||
| 41 | 17 | 28 | 6 | ||
| 7 | 18 | 12 | 40 | ||
| 8 | 19 | 30 | 41 | ||
| 9 | 20 | 31 | 42 | ||
| 10 | 43 | 32 | 21 | ||
| 11 | 22 | 33 | 44 | ||
| 29 | 23 | 34 | 45 |
| 1/1/1999 | Formatowanie warunkowe: | |
| 5/11/1999 | Formatowane są daty czerwcowe | |
| 9/18/1999 | ||
| 1/26/2000 | ||
| 6/4/2000 | ||
| 10/12/2000 | ||
| 2/19/2001 | ||
| 6/29/2001 | ||
| 11/6/2001 | ||
| 3/16/2002 | ||
| 7/24/2002 | ||
| 12/1/2002 |
| 8/19/2022 | Formatowanie warunkowe: | |
| 8/20/2022 | Formatowana jest dzisiejsza data | |
| 8/21/2022 | ||
| 8/22/2022 | ||
| 8/23/2022 | ||
| 8/24/2022 | ||
| 8/25/2022 | ||
| 8/26/2022 | ||
| 8/27/2022 | ||
| 8/28/2022 | ||
| 8/29/2022 | ||
| 8/30/2022 |
| 8/19/2022 | Friday | Formatowanie warunkowe: | |
| 8/20/2022 | Saturday | Formatowane są weekendy | |
| 8/21/2022 | Sunday | ||
| 8/22/2022 | Monday | ||
| 8/23/2022 | Tuesday | ||
| 8/24/2022 | Wednesday | ||
| 8/25/2022 | Thursday | ||
| 8/26/2022 | Friday | ||
| 8/27/2022 | Saturday | ||
| 8/28/2022 | Sunday | ||
| 8/29/2022 | Monday | ||
| 8/30/2022 | Tuesday |
| 0.00 | Formatowanie warunkowe: | |
| 1.00 | Formatowane są komórki zawierające błędy (ukryte) | |
| 2.00 | ||
| #DIV/0! | ||
| 2.00 | ||
| #DIV/0! | ||
| #DIV/0! | ||
| 45.00 | ||
| #N/A | ||
| #N/A | ||
| #N/A | ||
| #ADDIN? |
| 810 | Formatowanie warunkowe: | |
| 180 | Formatowana jest komórka zawierająca wartość maksymalną | |
| 215 | ||
| 595 | ||
| 139 | ||
| 765 | ||
| 632 | ||
| 658 | ||
| 206 | ||
| 75 | ||
| 368 | ||
| 113 | ||
| 820 | ||
| 578 | ||
| 872 | ||
| 817 | ||
| 540 | ||
| 916 | ||
| 296 | ||
| 925 | ||
| 591 | ||
| 655 | ||
| 243 | ||
| 993 | ||
| 973 | ||
| 611 | ||
| 191 | ||
| 363 | ||
| 973 | ||
| 386 |
| 777 | Formatowanie warunkowe: | |
| 243 | Formatowane są komórki zawierające 3 największe wartości | |
| 926 | ||
| 155 | ||
| 243 | ||
| 508 | ||
| 934 | ||
| 119 | ||
| 320 | ||
| 877 | ||
| 61 | ||
| 380 | ||
| 40 | ||
| 374 | ||
| 303 | ||
| 19 | ||
| 490 | ||
| 638 | ||
| 380 | ||
| 107 | ||
| 364 | ||
| 489 | ||
| 102 | ||
| 396 | ||
| 592 | ||
| 852 | ||
| 869 | ||
| 159 | ||
| 722 | ||
| 762 |
| 483 | 782 | 187 | 70 | Formatowanie warunkowe: | |
| 496 | 582 | 256 | 755 | Formatowane są naprzemienne wiersze | |
| 826 | 924 | 616 | 561 | ||
| 622 | 905 | 157 | 986 | ||
| 301 | 862 | 281 | 306 | ||
| 292 | 928 | 336 | 236 | ||
| 943 | 692 | 737 | 601 | ||
| 64 | 120 | 405 | 834 | ||
| 335 | 370 | 596 | 986 | ||
| 924 | 47 | 47 | 503 | ||
| 996 | 987 | 311 | 339 | ||
| 955 | 338 | 343 | 436 | ||
| 532 | 852 | 975 | 605 | ||
| 559 | 623 | 651 | 91 | ||
| 228 | 190 | 79 | 284 | ||
| 862 | 398 | 601 | 182 | ||
| 165 | 959 | 555 | 2 | ||
| 286 | 57 | 744 | 263 |
| 999 | 91 | 793 | 825 | Formatowanie warunkowe: | |
| 299 | 881 | 428 | 526 | Cieniowane są grupy czterowierszowe | |
| 894 | 406 | 415 | 946 | ||
| 181 | 578 | 767 | 97 | ||
| 400 | 212 | 805 | 899 | ||
| 881 | 334 | 245 | 880 | ||
| 745 | 772 | 941 | 439 | ||
| 513 | 488 | 826 | 598 | ||
| 542 | 985 | 342 | 17 | ||
| 629 | 95 | 731 | 787 | ||
| 704 | 996 | 382 | 597 | ||
| 170 | 501 | 800 | 482 | ||
| 819 | 346 | 384 | 735 | ||
| 920 | 242 | 472 | 271 | ||
| 667 | 842 | 0 | 183 | ||
| 166 | 3 | 261 | 437 | ||
| 793 | 239 | 935 | 940 | ||
| 131 | 269 | 732 | 142 | ||
| 245 | 737 | 138 | 977 | ||
| 714 | 898 | 260 | 919 | ||
| 373 | 790 | 895 | 5 | ||
| 441 | 559 | 755 | 940 |
| 794 | 145 | 77 | 596 | 801 | 544 | 929 | 401 | Formatowanie warunkowe: | |
| 487 | 329 | 32 | 113 | 324 | 307 | 699 | 946 | Plansza do warcabów | |
| 945 | 903 | 250 | 467 | 260 | 759 | 417 | 612 | ||
| 762 | 141 | 227 | 945 | 886 | 924 | 93 | 133 | ||
| 780 | 280 | 962 | 824 | 682 | 477 | 419 | 672 | ||
| 16 | 585 | 612 | 941 | 287 | 38 | 260 | 917 | ||
| 87 | 510 | 757 | 665 | 36 | 540 | 368 | 119 | ||
| 468 | 189 | 875 | 437 | 842 | 142 | 188 | 988 | ||
| 693 | 304 | 554 | 978 | 172 | 845 | 33 | 613 | ||
| 207 | 850 | 30 | 607 | 895 | 74 | 555 | 697 | ||
| 577 | 291 | 415 | 517 | 125 | 677 | 464 | 404 | ||
| 129 | 635 | 15 | 148 | 228 | 532 | 107 | 808 | ||
| 549 | 300 | 123 | 558 | 35 | 107 | 142 | 241 | ||
| 635 | 823 | 71 | 353 | 92 | 610 | 149 | 209 | ||
| 73 | 443 | 717 | 718 | 262 | 989 | 510 | 142 | ||
| 904 | 506 | 933 | 231 | 388 | 66 | 511 | 58 | ||
| 783 | 742 | 472 | 827 | 223 | 953 | 398 | 160 | ||
| 877 | 88 | 864 | 808 | 977 | 860 | 962 | 843 | ||
| 994 | 477 | 625 | 868 | 115 | 35 | 140 | 656 | ||
| 412 | 543 | 16 | 168 | 384 | 750 | 854 | 339 | ||
| 383 | 394 | 5 | 124 | 807 | 595 | 404 | 649 | ||
| 96 | 80 | 515 | 452 | 798 | 425 | 540 | 421 |
| 738 | 718 | 153 | 594 | Formatowanie warunkowe: | |
| 5 | 187 | 857 | 858 | Formatowane są duplikaty | |
| 938 | 681 | 16 | 310 | ||
| 521 | 292 | 725 | 160 | ||
| 768 | 46 | 856 | 950 | ||
| 883 | 191 | 399 | 456 | ||
| 539 | 225 | 142 | 383 | ||
| 769 | 245 | 51 | 277 | ||
| 260 | 395 | 878 | 739 | ||
| 321 | 271 | 685 | 944 | ||
| 941 | 301 | 131 | 624 | ||
| 987 | 200 | 348 | 210 |
| 136 | 314 | 723 | 955 | Formatowanie warunkowe: | |
| 347 | 303 | 756 | 67 | Formatowane są wszystkie wartości unikalne | |
| 99 | 440 | 611 | 429 | ||
| 840 | 923 | 574 | 877 | ||
| 263 | 950 | 494 | 871 | ||
| 646 | 102 | 656 | 482 | ||
| 350 | 882 | 718 | 176 | ||
| 340 | 888 | 159 | 281 | ||
| 843 | 926 | 386 | 73 | ||
| 911 | 144 | 34 | 783 | ||
| 950 | 456 | 108 | 850 | ||
| 863 | 676 | 457 | 952 |
| 100 | Formatowanie warunkowe: | |
| 105 | Formatowane są wartości nie posortowane | |
| 113 | ||
| 116 | ||
| 116 | ||
| 120 | ||
| 127 | ||
| 131 | ||
| 136 | ||
| 138 | ||
| 143 | ||
| 145 | ||
| 147 | ||
| 154 | ||
| 159 | ||
| 161 | ||
| 166 | ||
| 172 | ||
| 173 | ||
| 174 | ||
| 176 | ||
| 179 | ||
| 179 | ||
| 184 | ||
| 186 | ||
| 189 | ||
| 196 | ||
| 201 | ||
| 208 | ||
| 208 | ||
| 212 | ||
| 218 | ||
| 219 | ||
| 225 | ||
| 230 | ||
| 232 | ||
| 233 | ||
| 239 | ||
| 240 | ||
| 247 | ||
| 249 | ||
| 250 | ||
| 253 | ||
| 252 | ||
| 252 | ||
| 259 | ||
| 263 | ||
| 269 | ||
| 270 | ||
| 273 | ||
| 272 | ||
| 279 | ||
| 279 | ||
| 279 | ||
| 288 | ||
| 290 | ||
| 293 | ||
| 299 | ||
| 308 | ||
| 309 | ||
| 316 | ||
| 320 | ||
| 320 | ||
| 326 | ||
| 334 | ||
| 338 | ||
| 344 | ||
| 350 | ||
| 357 | ||
| 363 | ||
| 369 | ||
| 371 | ||
| 370 | ||
| 379 | ||
| 383 | ||
| 384 | ||
| 390 | ||
| 397 | ||
| 404 | ||
| 405 | ||
| 407 | ||
| 407 | ||
| 408 | ||
| 412 | ||
| 415 | ||
| 419 | ||
| 423 | ||
| 423 | ||
| 426 | ||
| 430 | ||
| 437 | ||
| 442 | ||
| 442 | ||
| 448 | ||
| 449 | ||
| 453 | ||
| 454 | ||
| 455 | ||
| 458 | ||
| 458 |
| 100 | Formatowanie warunkowe: | |
| 103 | Formatowane są ciągi malejące i rosnące | |
| 105 | ||
| 111 | ||
| 110 | ||
| 108 | ||
| 111 | ||
| 111 | ||
| 109 | ||
| 112 | ||
| 111 | ||
| 111 | ||
| 116 | ||
| 120 | ||
| 126 | ||
| 124 | ||
| 122 | ||
| 123 | ||
| 123 | ||
| 131 | ||
| 131 | ||
| 129 | ||
| 134 | ||
| 140 | ||
| 146 | ||
| 148 | ||
| 150 | ||
| 157 | ||
| 154 | ||
| 160 | ||
| 166 | ||
| 166 | ||
| 174 | ||
| 171 | ||
| 177 | ||
| 174 | ||
| 179 | ||
| 180 | ||
| 179 | ||
| 181 | ||
| 180 | ||
| 186 | ||
| 188 | ||
| 193 | ||
| 196 | ||
| 200 | ||
| 206 | ||
| 211 | ||
| 210 | ||
| 209 | ||
| 213 | ||
| 214 | ||
| 216 | ||
| 221 | ||
| 219 | ||
| 220 | ||
| 222 | ||
| 229 | ||
| 228 | ||
| 234 | ||
| 234 | ||
| 233 | ||
| 236 | ||
| 235 | ||
| 238 | ||
| 239 | ||
| 242 | ||
| 250 | ||
| 252 | ||
| 255 | ||
| 256 | ||
| 264 | ||
| 266 | ||
| 273 | ||
| 276 | ||
| 282 | ||
| 287 | ||
| 285 | ||
| 284 | ||
| 287 | ||
| 296 | ||
| 295 | ||
| 295 | ||
| 295 | ||
| 295 | ||
| 297 | ||
| 294 | ||
| 295 | ||
| 302 | ||
| 303 | ||
| 300 | ||
| 301 | ||
| 308 | ||
| 314 | ||
| 316 | ||
| 313 | ||
| 314 | ||
| 320 | ||
| 318 | ||
| 324 |
| Excel | Formatowanie warunkowe: | |
| Microsoft Excel | Formatowane są komórki zawierające więcej niż jedno słowo | |
| Formuły | ||
| 123 434 55 | ||
| Dwa słowa | ||
| Tutaj trzy słowa | ||
| Jeden | ||
| Dwa | ||
| 1234 | ||
| 123-39-0988 |
| Krowa | Formatowanie warunkowe: | |
| Pies | Formatowane są komórki zawierające literę A | |
| Formuła | ||
| Kot | ||
| Tajemniczy | ||
| Tutaj trzy słowa | ||
| Alfa | ||
| 54556 | ||
| AAA | ||
| ABCDEFGHIJK |
| Wartość 1: | 36 | Formatowanie warunkowe: | |
| Wartość 2 | 44 | SUMA pojawia się tylko wtedy, gdy podano wszystkie 4 wartości. | |
| Wartość 3 | 34 | ||
| Wartość 4 | 23 | ||
| SUMA | 137 |
| Student | Test początkowy | Test końcowy | Formatowanie warunkowe: | |
| Anna | 89 | 93 | Formatowane są tylko wiersz, w których wystąpił postęp | |
| Bogdan | 91 | 90 | ||
| Krzysztof | 75 | 81 | ||
| Daria | 65 | 73 | ||
| Edward | 90 | 81 | ||
| Franciszek | 93 | 100 | ||
| Jerzy | 89 | 89 | ||
| Hanna | 99 | 98 | ||
| Ignacy | 54 | 69 | ||
| Jan | 60 | 75 | ||
| Karol | 89 | 88 |