23-11-2010, 11:44 | #1 |
Absinthe
Join Date: Jan 2007
Location: Chester
Posts: 2,345
|
Excel formula - apply to entire workbook?
So, I've got a formula to create alternate row highlighting:
=MOD(ROW()-2,1*2)+1<=1 Is it possible to modify that so that it would be applied to all worksheets? I tried an ='A:Z'! but didn't know how to merge that with the existing statement. |