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> )_~

 

[Festus Hagen]

came out OK here (I included the formulae in the cells too):
http://www.excel-jeanie-html.de/index.php?f=1

Duh ... I suspect removing the current manual formatting would solve the problem.

Thank you ... It works PERFECT!!!!!

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

 

[ankurshrestha]

I like the solution by HotPaper.