alternating rows colours

  • Thread starter Thread starter braziliandp
  • Start date Start date
B

braziliandp

hi,

i'm a excel2000 user and have tried to use the formula
=mod(row(),2)=0 and =mod(row(),2)=1 but a error message is displayed
if i change the"," to ";" the program accepts but the formula doesn'
work.
i've created a data base in excel2000 the only problem is to us
differents colours to alternate rows.
what can i do?????
 
Hi Brazil....,
When using Conditional Formatting you must make a
selection first of the cells that are going to be formatted (colored).
In this case you would select all cells Ctrl+A

Doesn't work is not a very good description, but will assume
in this case it means didn't see anything happen
which is what you might have if you just had one cell selected.
A single cell selection is often expanded to the used range (Ctrl+*).

I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
and I expect you visited Chip Pearson's page, if not, take a look
http://www.cpearson.com/excel/banding.htm

The comma, period, and semicolon usage are dependent
on your regional control panel settings which reflect your spoken and
written language (language version of Excel).
 
Hi braziliandp

As an alternative, you may like to try the following code although the
resultant shading will not hold as you delete / insert rows. You can of
course rerun the macro each time the database changes

'Select range to be formatted before running macro
Sub ShadeEveryOtherRow()
Selection.AutoFormat Format(xlRangeAutoFormatList1), _
False, False, False, False, True, False
End Sub

--
XL2002
Regards

William

(e-mail address removed)

| hi,
|
| i'm a excel2000 user and have tried to use the formula
| =mod(row(),2)=0 and =mod(row(),2)=1 but a error message is displayed.
| if i change the"," to ";" the program accepts but the formula doesn't
| work.
| i've created a data base in excel2000 the only problem is to use
| differents colours to alternate rows.
| what can i do??????
|
|
| ---
| Message posted
|
 
for all that have written to help me i'd like to say "thank you", i'v
already be able to use the formula correctly. in this version the righ
to use is "=mod(lin();2)=0" and "=mod(lin();2)=0".
Once more thank you..
 
Back
Top