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.