Thread: Can one conditionally format a WS to leave everyother row blank?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Can one conditionally format a WS to leave everyother row blank?
Not by formatting.

Why would you want this feature?

If just for appearance, just select a great gaggle of rows and set the height to
double what it is now.

Or select a great gaggle of rows and FormatConditional FormatFormula is

=MOD(ROW(),2)=1

Format to white font and the rows will look blank.


Gord Dibben MS Excel MVP


On Fri, 4 May 2007 09:01:04 -0700, Drew wrote:

I know how to format every other row for different colors, but can Excel
leave every other row blank?

Reply With QuoteReply With Quote