How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- Office Version
- 2010
- Platform
- Windows
Hi all, I can’t see where I’m going wrong with the following…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
The first Jeanie is working, my conditional formatting is correct…
<o> </o>
What I want to do is delete the yellow cells…
<o> </o>
So in the second Jeanie my red conditional formatting is incorrect… Where am I going wrong with my formulas please?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
The first Jeanie is working, my conditional formatting is correct…
<o> </o>
What I want to do is delete the yellow cells…
<o> </o>
So in the second Jeanie my red conditional formatting is incorrect… Where am I going wrong with my formulas please?
Excel Workbook | |||
---|---|---|---|
M | |||
17 | |||
18 | |||
19 | |||
20 | |||
21 | |||
22 | |||
23 | |||
24 | |||
25 | |||
26 | |||
27 | |||
28 | Away Loss (M) | ||
29 | Home Win | ||
30 | Home Draw | ||
31 | Home Loss | ||
% Percentage |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
M28 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$25:$M$39,0)-24)<=3,(ROW()-MATCH($D$21,$M$25:$M$39,0)-24)>0) | Abc | ||
M29 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$25:$M$39,0)-24)<=3,(ROW()-MATCH($D$21,$M$25:$M$39,0)-24)>0) | Abc | ||
M30 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$25:$M$39,0)-24)<=3,(ROW()-MATCH($D$21,$M$25:$M$39,0)-24)>0) | Abc | ||
M31 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$25:$M$39,0)-24)<=3,(ROW()-MATCH($D$21,$M$25:$M$39,0)-24)>0) | Abc |
Excel Workbook | |||
---|---|---|---|
M | |||
17 | |||
18 | |||
19 | Away Loss (M) | ||
20 | Home Win | ||
21 | Home Draw | ||
22 | Home Loss | ||
23 | Away Draw (M) | ||
24 | Home Win | ||
25 | Home Draw | ||
26 | Home Loss | ||
27 | Away Win (M) | ||
28 | Home Win | ||
29 | Home Draw | ||
30 | Home Loss | ||
% Percentage |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
M19 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M20 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M21 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M22 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M23 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M24 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M25 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M26 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M27 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M28 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M29 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc | ||
M30 | 1. / Formula is =AND((ROW()-MATCH($D$21,$M$17:$M$30,0)-24)<=3,(ROW()-MATCH($D$21,$M$17:$M$30,0)-24)>0) | Abc |