Thread: Can one conditionally format a WS to leave everyother row blank?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Can one conditionally format a WS to leave everyother row blank?
Blank? Not with a conditional format. You could change the font color to
be the same as the background color and it would appear blank, but wouldn't
be blank. You'd have to use VBA to get every other row blank.

"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