Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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? "Ken" wrote: 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 |
#3
![]() |
|||
|
|||
![]()
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/2TRUNC(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.51 = TRUE, ODD will show up. Say A1 = 4, 4/2 = 2, TRUNC(2) = 2 22 = FALSE, EVEN. Not sure if that's what you're looking for, but hope it helped. "Ken" wrote: 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 |
#4
![]() |
|||
|
|||
![]()
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" wrote in message ... 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 |
#5
![]() |
|||
|
|||
![]()
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 ... -----Original Message----- 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" wrote in message ... 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 . |
#6
![]() |
|||
|
|||
![]()
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. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Ken" wrote in message ... 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 ... -----Original Message----- 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" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format | Excel Worksheet Functions | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
make a conditional format the default | Excel Discussion (Misc queries) | |||
Copying a conditional format | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |