Conditional Formatting

How_Do_I

Well-known Member
Joined
Oct 23, 2009
Messages
1,843
Office Version
  1. 2010
Platform
  1. Windows
Hi all, I can’t see where I’m going wrong with the following…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
The first Jeanie is working, my conditional formatting is correct…
<o:p> </o:p>
What I want to do is delete the yellow cells…
<o:p> </o:p>
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
28Away Loss (M)
29Home Win
30Home Draw
31Home Loss
% Percentage
Cells with Conditional Formatting
CellConditionCell FormatStop If True
M281. / 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
M291. / 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
M301. / 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
M311. / 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
19Away Loss (M)
20Home Win
21Home Draw
22Home Loss
23Away Draw (M)
24Home Win
25Home Draw
26Home Loss
27Away Win (M)
28Home Win
29Home Draw
30Home Loss
% Percentage
Cells with Conditional Formatting
CellConditionCell FormatStop If True
M191. / 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
M201. / 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
M211. / 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
M221. / 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
M231. / 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
M241. / 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
M251. / 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
M261. / 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
M271. / 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
M281. / 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
M291. / 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
M301. / 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
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Forget this one folks it's sorted...

Talking of sorted, when will Fernando Torres score for my beloved Blues...
01 Mar 11 a hatrick... :eeek:
 
Upvote 0

Forum statistics

Threads
1,224,516
Messages
6,179,231
Members
452,898
Latest member
Capolavoro009

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top