1
00:00:00,080 --> 00:00:05,445
Our fictional status tracker has three Late tasks: W-02, W-04 and W-06.

2
00:00:05,445 --> 00:00:09,380
The formatting rule appears to work for the first two but

3
00:00:09,380 --> 00:00:10,811
misses the last row.

4
00:00:10,811 --> 00:00:14,745
The likely issue in this controlled example is its Apply to

5
00:00:14,745 --> 00:00:16,176
range ending too early.

6
00:00:16,176 --> 00:00:20,111
We will check the rule and the final rows, not just

7
00:00:20,111 --> 00:00:21,541
trust a colored cell.

8
00:00:22,141 --> 00:00:24,430
Open the original fictional practice workbook.

9
00:00:24,430 --> 00:00:28,626
Its table fills A1 through C7: column A is Task ID,

10
00:00:28,626 --> 00:00:31,296
B is Status, and C is Owner.

11
00:00:31,296 --> 00:00:35,492
A formula rule is already installed over A2 through C6 with

12
00:00:35,492 --> 00:00:37,781
the Late condition and a fill.

13
00:00:37,781 --> 00:00:43,121
It covers W-02 and W-04 but misses W-06 on row 7.

14
00:00:43,121 --> 00:00:47,699
You can inspect and repair that real rule in a disposable copy.

15
00:00:48,299 --> 00:00:52,377
In Excel for the web, select Home, Conditional Formatting, Manage Rules.

16
00:00:52,377 --> 00:00:56,825
Microsoft's current help says the task pane can display rules for

17
00:00:56,825 --> 00:00:58,679
the current selection or sheet.

18
00:00:58,679 --> 00:01:03,869
Choose the sheet scope if the rule seems missing from the selected-cell view.

19
00:01:04,469 --> 00:01:10,710
For this example, a rule applied to A2:C6 cannot format W-06 on row 7.

20
00:01:10,710 --> 00:01:15,000
Edit the rule and set Apply to range to A2:C7.

21
00:01:15,000 --> 00:01:20,070
Excel's web help explicitly instructs you to verify or adjust this field.

22
00:01:20,070 --> 00:01:24,361
Confirm the final row is inside the rule, rather than adding

23
00:01:24,361 --> 00:01:25,921
a second overlapping rule.

24
00:01:26,521 --> 00:01:30,721
If the rule is formula-based, the intended condition is equals Late

25
00:01:30,721 --> 00:01:32,822
in column B for each row.

26
00:01:32,822 --> 00:01:37,722
Use the practice formula shown here, with column B fixed and the row relative.

27
00:01:37,722 --> 00:01:41,573
A formula that always points to B2 would produce the wrong

28
00:01:41,573 --> 00:01:42,973
pattern down the table.

29
00:01:42,973 --> 00:01:45,423
Inspect the actual rule before changing it.

30
00:01:46,023 --> 00:01:49,804
If the range and formula are right but colors still conflict,

31
00:01:49,804 --> 00:01:53,240
inspect other rules on the same sheet and their order.

32
00:01:53,240 --> 00:01:56,677
Excel's rule manager lets you see and edit them.

33
00:01:56,677 --> 00:02:00,457
This branch is for an actual overlap; do not delete unrelated

34
00:02:00,457 --> 00:02:02,863
rules to make one example look right.

35
00:02:03,463 --> 00:02:10,721
After saving, compare W-02, W-04 and W-06 with W-01, W-03 and W-05.

36
00:02:10,721 --> 00:02:14,753
If all rows are colored, the condition is too broad.

37
00:02:14,753 --> 00:02:18,785
If only the bottom row is plain, recheck the range.

38
00:02:18,785 --> 00:02:24,431
The answer is the exact set of IDs, not a general impression of color.

39
00:02:25,031 --> 00:02:29,451
This exercise passes when the rule applies to A2:C7, its formula

40
00:02:29,451 --> 00:02:34,608
is relative by row, and the three Late rows alone receive the chosen fill.

41
00:02:34,608 --> 00:02:37,924
Check the actual row colors in your Excel copy.

42
00:02:37,924 --> 00:02:42,713
If W-06 is still plain or a non-Late row is filled,

43
00:02:42,713 --> 00:02:46,397
revisit the range and rule before calling the fix complete.