Slide 501 [Showing 3 variations of coloring only the selected cell, or its row and column across the entire spreadsheet, or just inside the cell's current region. Can also be accomplished with Conditional Formatting to not disturb other existing colors on the spreadsheet.]

Slide 502 [Showing the INDIRECT function to use cell values that refer to worksheet tab names.]

Slide 503 [Using a Worksheet_Change event to force a negative number entry in certain ranges.]

Slide 504 []

Slide 505 []

Slide 506 []

Slide 507 []

Slide 508 []

Slide 509 []

Slide 510 []

Slide 511 []

Slide 512 []

Slide 513 []

Slide 514 []

Slide 515 []

Slide 516 []

Slide 517 []

Slide 518 []

Slide 519 []

Slide 520 []

Slide 521 []

Slide 522 []

Slide 523 []

Slide 524 []

Slide 525 []

Slide 526 []

Slide 527 []

Slide 528 []

Slide 529 []

Slide 530 []

Slide 531 []

Slide 532 []

Slide 533 []

Slide 534 []

Slide 535 []

Slide 536 []

Slide 537 []

Slide 538 []

Slide 539 []

Slide 540 []

Slide 541 []

Slide 542 []

Slide 543 []

Slide 544 []

Slide 545 []

Slide 546 []

Slide 547 []

Slide 548 []

Slide 549 []

Slide 550 []

Slide 551 []

Slide 552 []

Slide 553 []

Slide 554 []

Slide 555 []

Slide 556 []

Slide 557 []

Slide 558 []

Slide 559 []

Slide 560 []

Slide 561 []

Slide 562 []

Slide 563 []

Slide 564 []

Slide 565 []

Slide 566 []

Slide 567 []

Slide 568 []

Slide 569 []

Slide 570 []

Slide 571 []

Slide 572 []

Slide 573 []

Slide 574 []

Slide 575 []

Slide 576 []

Slide 577 []

Slide 578 []

Slide 579 []

Slide 580 []

Slide 581 []

Slide 582 []

Slide 583 []

Slide 584 []

Slide 585 []

Slide 586 []

Slide 587 []

Slide 588 []

Slide 589 []

Slide 590 []

Slide 591 []

Slide 592 []

Slide 593 []

Slide 594 []

Slide 595 []

Slide 596 []

Slide 597 []

Slide 598 []

Slide 599 []

Slide 600 []