Windows Forum

Ask something
Discussion Locked

Excel-formatting

0 helpful
3 replies

by sakil

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to use paragraph and line formatting in Excel?

3 replies

by cdcents

Not sure if this is what you are asking but yes you can have alternate rows (or columns) in the same format. All even numbered rows can be formatted one way and all odd numbered rows can be formatted another.
to do this highlight all rows to formatthen use conditional formatting (Format - conditional formatting)
Select "formula is" and then type in the formula
=MOD(ROW(),2)=0
Finally slect a format (eg. Select a background pattern for the rows or may be a font colour or even a font)

Alternately you can format based on cell value.
Let me know if you need more help...CD

This discussion is closed to new replies.