Conditional formatting

[reno]

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.

 

[Bernie Deitrick]

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

 

[Bernie Deitrick]

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

 

[reno]

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]

that worked great...thx

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

 

[samantha]

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

 

[Gord Dibben]

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