Conditional Formatting

[Jstump]

How would i get this sheet to alternate rows between2 different cell style but link it to where it does not apply if there is no data the column A? the sheet can be anywhere between 2 rows or 4000.

Kane 1.xlsx
	A	B	C	D	E	F
1	PIER #	PILE TYPE	STRUCTURE NAME	LEAD DESCRIPTION	EXTENSION DESCRIPTION	CAP DESCRIPTION
2	HP-01
3	HP-02
4	HP-03
5	HP-04
6	HP-05
7	HP-06
8	HP-07
9	HP-08
10	HP-09
11	HP-10
12	HP-11
13	HP-12
14	HP-13
15	HP-14
16	HP-15
17	HP-16
18	HP-17
19	HP-18
20	HP-19
21	HP-20
As-built 1

Cell Formulas
Range	Formula
A2:A21	A2	="HP-"&TEXT(SEQUENCE('Input page'!B3),"00")
D2:D21	D2	=FILTER('Input page'!$D$4:$F$9,'Input page'!$C$4:$C$9=$B2,"")
Dynamic array formulas.

 

[PeteWright]

alternating row styles can be achieved with Conditional Formatting formulas: =MOD(ROW(),2)=0 and =MOD(ROW(),2)=1

Book1
	A	B	C	D	E	F
1	BLAH	BLAH	BLAH	BLAH	BLAH	BLAH
2	dummy1
3	dummy2
4	dummy3
5	dummy4
6	dummy5
7	dummy6
8	dummy7
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F8	Expression	=MOD(ROW(),2)=0	text	NO
A2:F8	Expression	=MOD(ROW(),2)=1	text	NO

How would i get this sheet to alternate rows between2 different cell style but link it to where it does not apply if there is no data the column A? the sheet can be anywhere between 2 rows or 4000.

For the other part I don't know what you mean.

 

[Jstump]

I ended up using =AND(LEN($A1) > 0, MOD(ROW(), 2) = 0) for even rows and
=AND(LEN($A2) > 0, MOD(ROW(), 2) <> 0) for odd rows


Thanks for answering though!

 

[Joe4]

Note that you do not need to use the MOD function to calculate even and odd values. Excel already has functions ISODD and ISEVEN.

=ISODD(ROW())

=ISEVEN(ROW())