conditional formating shadow to alternating

[webdevptg]

Hi,

I need to apply shadow to alternating lines that are ordered by country.
I've made a series of attempts with the mod function and counting but nothing produces the effects I want.

Download example

 

[mart37]

with a hidden column:

Map1
	B
2	1
Blad1

Cell Formulas
Range	Formula
B2	B2	=IF($A2=$A1,$B1,IF($B1=1,0,1))

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[webdevptg]

with a hidden column:

Map1
	B
2	1
Blad1

Cell Formulas
Range	Formula
B2	B2	=IF($A2=$A1,$B1,IF($B1=1,0,1))

I was trying to make the formula in conditional formatting, but it also works
Thanks

 

[Fluff]

For 365

+Fluff v2.xlsm
	A	B	C
1	County	District	Ward
2	Buckinghamshire	Wycombe	Hambleden Valley
3	Cornwall	Cornwall	St Teath and St Breward
4	County Durham	County Durham	Stanley
5	Cumbria	Eden	Ullswater
6	Cumbria	Eden	Crosby Ravensworth
7	Derbyshire	Amber Valley	Alport
8	Derbyshire	Derbyshire Dales	Bradwell
9	Derbyshire	High Peak	Padfield
10	Devon	Torridge	Waldon
11	Devon	Teignbridge	Teign Valley
12	Dorset	North Dorset	Shaftesbury West
13	Gloucestershire	Cotswold	Ermin
14	Greater Manchester	Stockport	Marple South
15	Greater Manchester	Oldham	Royton South
16	Greater Manchester	Oldham	St Mary's
17	Greater Manchester	Oldham	Shaw
18	Greater Manchester	Rochdale	Norden
19	Herefordshire	Herefordshire, County of	Bishops Frome & Cradley
20	Lancashire	Pendle	Boulsworth
21	Lancashire	Pendle	Old Laund Booth
22	Lancashire	Blackburn with Darwen	Shadsworth with Whitebirk
23	North Yorkshire	Hambleton	Osmotherley & Swainby
24	Oxfordshire	Cherwell	Cropredy, Sibfords and Wroxton
25	Shropshire	Shropshire	Cleobury Mortimer
26	South Yorkshire	Sheffield	Richmond
27	Staffordshire	Stoke-on-Trent	Birches Head and Central Forest Park
28	Staffordshire	Stoke-on-Trent	Great Chell and Packmoor
29	Staffordshire	Cannock Chase	Rawnsley
30	Surrey	Waverley	Haslemere Critchmere and Shottermill
31	West Midlands	Birmingham	Longbridge
32	West Midlands	Birmingham	Quinton
33	West Yorkshire	Kirklees	Kirkburton
34	West Yorkshire	Kirklees	Colne Valley
35	West Yorkshire	Bradford	Tong
36	West Yorkshire	Bradford	Bowling and Barkerend
37	West Yorkshire	Bradford	City
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C37	Expression	=MOD(COUNTA(UNIQUE(FILTER($A$1:$A2,$A$1:$A2<>""))),2)=0	text	NO