alternating coloured rows

K

Kalabalana

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

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
 
K

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
 
K

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
 
W

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

[email protected]

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

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 **
 
K

Kalabalana

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

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

[email protected]

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

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

[email protected]

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

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
 
W

William

Hi

Shade the uncolored cells white

--
XL2002
Regards

William

[email protected]

| 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
|
|
| ---
|
|
 
Top