Can one conditionally format a WS to leave everyother row blank?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to format every other row for different colors, but can Excel
leave every other 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.
 
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 Format>Conditional Format>Formula is

=MOD(ROW(),2)=1

Format to white font and the rows will look blank.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditionally formatting 3
Conditional Formatting using blocks of rows 7
Conditional Formatting in Excel when data changes 0
Formatting As Table with OUT header row formatting 5
Excel Conditional Formatting 1
Conditional row format 3
How to reset every other row color after sorting 2
Comparison of columns using Conditional Formatting 3

Back
Top