alternating coloured rows

  • Thread starter Thread starter Kalabalana
  • Start date Start date
K

Kalabalana

simply I would like to have every other row to be one colour, the lef
over rows to be another colou
 
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
 
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
 
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
 
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
|
 
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 **
 
thanks
is there anyways to disable gridlines for a selection though? while th
rest of the worksheet remains the same
 
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
|
 
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, 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
 
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
|
 
Back
Top