Conditional formatting
 

have a set of 200 stores, each w/unique store# and 7 add'l columns of info,
each store might have 1 to 10 entries. Entries are sorted by store # and date

Would like to cond format such that all even number store rows are one color
and all odd are another color or whie by default. Tried several approaches
w/o success. Prefer cond formatting rather than going row by row manually.

reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.

And in case anybody is wondering, Excel doesn't allow the use of the ISODD
function in conditional formatting, because it is part of the Analysis
toolpak. You should get an error if you try it.

HTH,
Bernie
MS Excel MVP

"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

"Bernie Deitrick" wrote:

reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.

that worked great...thx

"Bernie Deitrick" wrote:

reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.

Conditional formatting
 

i cant figure it out, got a list of data here and needs to format the cells
of odd numbers.

"Bernie Deitrick" wrote:

reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.

Conditional formatting
 

Select the range of cells then enter this revision to Bernie's formula.

=$A1/2=INT($A1/2)=FALSE

Will CF odd numbers only.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 12:44:01 -0700, samantha
wrote:

i cant figure it out, got a list of data here and needs to format the cells
of odd numbers.

"Bernie Deitrick" wrote:

reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.