Checkerboard formatting 2 Rows by 1 Column

[Festus Hagen]

Hi All

Does anyone know a way to do conditional formatting (VBA method would work as well) to checkerboard 2 rows by 1 column???

Thanks

-Enjoy
fh <font color="#FF0000">:</font> )_~

 

[Scott Huish]

Is this what you want?

Select your column

Conditional Formatting formula:

=MOD(ROW(),3)

 

[Tom Urtis]

Well, let's say your desired range is A1:A2 which is the size of a range you specified in your post that is 2 rows by 1 column.

Select that range, go to the Conditional Formatting dialog, and use this as the formula rule:

=MOD(ROW(),2)=MOD(COLUMN(),2)

Select a pattern color and click OK.

This formula will also work for more rows than just two, or for a two-row and multiple column range.

Edit:
Or maybe/probably I am totally wrong and Hotpepper got it right.

 

[p45cal]

…or
=ISEVEN(ROW()+COLUMN())

 

[Scott Huish]

If that's what the op wants, this will work as well:

=MOD(ROW()+COLUMN(),2)

 

[Festus Hagen]

Sorry folks, Guess I wasn't clear ...

I have a large range (couple thousand rows) that I want to checkerboard 2 rows by 1 column.

Thus cells would be colored like
GREEN WHITE GREEN WHITE
GREEN WHITE GREEN WHITE
WHITE GREEN WHITE GREEN
WHITE GREEN WHITE GREEN
GREEN WHITE GREEN WHITE
GREEN WHITE GREEN WHITE

Thanks

-Enjoy
fh <font color="#FF0000">:</font> )_~

 

[Scott Huish]

=(mod(row()-1,4)<2)+mod(column(),2)-1

 

[Festus Hagen]

=(mod(row()-1,4)<2)+mod(column(),2)-1

Thanks HotPepper, but that doesn't come out as desired, it winds up Like:
GREEN GREEN GREEN
GREEN GREEN GREEN
GREEN WHITE GREEN
WHITE GREEN WHITE
GREEN GREEN GREEN
GREEN GREEN GREEN
GREEN WHITE GREEN
WHITE GREEN WHITE

-Enjoy
fh : )_~

 

[p45cal]

came out OK here (I included the formulae in the cells too):

Excel Workbook
	R	S	T	U	V
41	0	1	0	1	0
42	0	1	0	1	0
43	-1	0	-1	0	-1
44	-1	0	-1	0	-1
45	0	1	0	1	0
46	0	1	0	1	0
47	-1	0	-1	0	-1
48	-1	0	-1	0	-1
49	0	1	0	1	0
50	0	1	0	1	0
51	-1	0	-1	0	-1
52	-1	0	-1	0	-1
53	0	1	0	1	0
54	0	1	0	1	0
55	-1	0	-1	0	-1
56	-1	0	-1	0	-1
Sheet6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R41	1. / Formula is =(MOD(ROW()-1,4)<2)+MOD(COLUMN(),2)-1	Abc

 

[mikerickson]

=MOD(INT(ROW()/2+COLUMN()),2)
or
=MOD(INT(ROW(A2)/2+COLUMN(A2)),2)