Auto Cell Shading

J

JackJJW

Perhaps a simple question. Is there a way of creating a database that
automatically will shade rows alternate colours once an entry has been
added?

E.g....

Row 1 = white
Row 2 = grey
Row 3 = white
Row 4 = grey

At the moment I have simply created a table by hand to allow other
people to enter data over the pre-shaded cells but this creates issues
when printing as it simply prints reams of blank pages with just the
shaded cells on.

Thanks very much in advance!

Jack
 

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

Row Shading 1
Spreadsheet suddenly changes format as I type 1
Cell shading with conditional formatting 5
shading alternate rows, but losing format when one row is deleted 8
Shading a cell relative to three other cells & repeat 3
Conditional Formatting Shading For Visible Rows Only 3
shading every other cell 2
sort columns, but not shading 3

Top