Conditional Format?

[Ken]

Excel 2000 ... What I have

Col A ... consist of random alpha-numeric part numbers
that when sorted (Ascending) ... may have multiple "odds"
or multiple "evens" in a row.

Above said ... I would like to set Conditional Formatting
to high-lite every other part number.

What might that Conditional Formula be?

Thanks ... Kha

 

[Guest]

Not sure I'm clear on what you want to do, but if I am I don't see how
"conditional" formatting is going to work. The records in alternating rows
would have to meet/not meet the condition. The way I understand the nature of
you data and the Asc sort, this isn't going to happen.

Why can't you just format all ODD ROW cells in col. A one way & format the
EVEN ROW cells another? That would give your alternating formatting
regardless of what the cell content was or how the column is sorted.

What am I missing?

 

[Guest]

Ken,

If I'm correct, you want to have a one format for odd part numbers and one
for even part numbers. I don't think that's possible within the software.

One possible solution to your problem could be to add a column next to your
parts list. Within the column use this function
=IF(A1/2>TRUNC(A1/2,0),"ODD","EVEN"). Then you can use the conditional
format for that column to differentiate between odd and even part numbers. A
test of the function with A1 = 3, 3/2 = 1.5, TRUNC(1.5)=1. 1.5>1 = TRUE, ODD
will show up. Say A1 = 4, 4/2 = 2, TRUNC(2) = 2 2>2 = FALSE, EVEN.

Not sure if that's what you're looking for, but hope it helped.

 

[Jim May]

Click on first Row-header desired, then Conditional Formatting
Formula is: and in box enter =MOD(ROW(),2)=1; enter pattern desired, OK
out.
Click again on same Row-header, then click the Format-Painter Icon
left-click the Row-header immediately below and drag-down (staying inside
the row-header column) as far as you'd like to have the formatting go.
HTH

 

[Ken]

Excel 2000 ... Ok ... time to clarify ...

ColA ... I have random apha-numeric part numbers that
often repeat ... So when sorted (Ascending) I may have 1
occs of 1 pn ... & 5 occs of another pn etc ... Also I
may have multiple "odd" or "even" pns in a row.

Part # ... High-Light
Format color
123456 ... Red
123456 ... Red
123456 ... Red
234567 ... Green
234567 ... Green
345678 ... Red
345680 ... Green
345680 ... Green
etc

I wish to set Conditional formatting to high-lite every
other "like" pn ... Thanks Kha ...

 

[Earl Kiosterud]

Ken,

The following is for where the p/n is in column A, starting in A2, down.
PUt the following in column B (helper column) (you can hide it), starting in
B2. Copy down.

=IF(A2=A1,B1,MOD(B1+1,2))

B1 should be empty, or 0 or 1.

Select your rows, or parts thereof. FOrmat - Conditional format - Formula
is. This is for where the active (white) cell of your selection is in row
2. Change the 2 in the formula to match:

=$B2=1

Select your format color.