alternating coloured rows

[Kalabalana]

simply I would like to have every other row to be one colour, the lef
over rows to be another colou

 

[Domenic]

Hi,

You can use Conditional Formatting for this.

1) Select your data/range of cells
2) Format > Conditional Formatting
3) Condition 1 > Formula Is > =MOD(ROW(),2)=1, and choose you
formatting
4) Condition 2 > Formula Is > =MOD(ROW(),2)=0, and choose you
formatting
5) Click Ok

Hope this helps

 

[Kalabalana]

haha excellent I was actually trying that but I found no information o
constructin my own paramters for the formatting, ty very much!

hey I just entered your info and had a problem, nothing happened,
maty have made a mistake entering it, but I highly doubt that, how do
check existing conditional formatting?

edit: figured it all out, so nvm the abov

 

[Domenic]

Highlight the same data/range of cells, and then Format > Conditiona
Formatting

 

[Kalabalana]

hey I have a quick follow up question, even more menial, how do I have
worksheet set up so the the borders are not not drawn at all? I do no
mean in the print out, but rather no borders seen at all on what th
program shows yo

 

[William]

Hi Kalabalana

You may want to try this macro. Select the range you want to format and then
run the macro....

Sub FormatSelection()
Selection.AutoFormat Format:=xlRangeAutoFormatList1
End Sub
--
XL2002
Regards

William

(e-mail address removed)

| simply I would like to have every other row to be one colour, the left
| over rows to be another colour
|
|
| ---
| Message posted
|

 

[Paul B]

kalabalane, try tools, options, view, and uncheck gridlines

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Kalabalana]

thanks
is there anyways to disable gridlines for a selection though? while th
rest of the worksheet remains the same

 

[William]

Hi

I assume by gridlines, you mean borders? If so, try amending the macro to as
shown below which will ensure the resultant formatting will be free from
borders. [If, in fact, you do mean gridlines, you'll find gridlines
disappear
once you have "colored" a cell.]

Sub FormatSelection()
Selection.AutoFormat Format(xlRangeAutoFormatList1), _
True, True, True, False, True, True
End Sub


--
XL2002
Regards

William

(e-mail address removed)

| thanks
| is there anyways to disable gridlines for a selection though? while the
| rest of the worksheet remains the same?
|
|
| ---
| Message posted
|

 

[William]

Hi

I assume by gridlines, you mean borders? If so, try amending the macro to as
shown below which will ensure the resultant formatting will be free from
borders. [If, in fact, you do mean gridlines, you'll find gridlines
disappear once you have "colored" a cell.]

Sub FormatSelection()
Selection.AutoFormat Format(xlRangeAutoFormatList1), _
True, True, True, False, True, True
End Sub

--
XL2002
Regards

William

(e-mail address removed)

| thanks
| is there anyways to disable gridlines for a selection though? while the
| rest of the worksheet remains the same?
|
|
| ---
| Message posted
|

 

[Kalabalana]

william, I was hoping there was a way to have a selection of uncoloure
cells without the gridlines showing, while in other places of the shee
they are still present. I am at no point referring to border

 

[William]

Hi

Shade the uncolored cells white

--
XL2002
Regards

William

(e-mail address removed)

| william, I was hoping there was a way to have a selection of uncoloured
| cells without the gridlines showing, while in other places of the sheet
| they are still present. I am at no point referring to borders
|
|
| ---
| Message posted
|