I'm working with copies of someone else's SAP files.

Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".

After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.

Notifications have distinct numbers, as do work orders.

So you may have:

NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to three
0001 | 2985 | Lubed
0001 | 2985 | Closed with comments


A vast majority of the time, ONE notification will lead to ONE AND
ONLY ONE work order. There are SOME notifications that lead to two (or
more) work orders.

I need to find a way to highlight those that lead to two or more.

The best I could come up with was:
- Sort
- Do a lookup (which would return the FIRST work order associated with
that)
- Have a column, IF LOOKUP = WORK ORDER, 0, 1
- Sort on that 1

But that seems clunky and inaccurate.

Thanks

Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)1

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob (MVP - Excel)


"RJB" wrote:

I'm working with copies of someone else's SAP files.

Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".

After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.

Notifications have distinct numbers, as do work orders.

So you may have:

NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to three
0001 | 2985 | Lubed
0001 | 2985 | Closed with comments


A vast majority of the time, ONE notification will lead to ONE AND
ONLY ONE work order. There are SOME notifications that lead to two (or
more) work orders.

I need to find a way to highlight those that lead to two or more.

The best I could come up with was:
- Sort
- Do a lookup (which would return the FIRST work order associated with
that)
- Have a column, IF LOOKUP = WORK ORDER, 0, 1
- Sort on that 1

But that seems clunky and inaccurate.

Thanks
.

On Apr 7, 11:00*pm, Jacob Skaria
wrote:
Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)1

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob (MVP - Excel)

"RJB" wrote:
I'm working with copies of someone else's SAP files.

Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".

After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.

Notifications have distinct numbers, as do work orders.

So you may have:

NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to three
0001 | 2985 | Lubed
0001 | 2985 | Closed with comments

A vast majority of the time, ONE notification will lead to ONE AND
ONLY ONE work order. There are SOME notifications that lead to two (or
more) work orders.

I need to find a way to highlight those that lead to two or more.

The best I could come up with was:
- Sort
- Do a lookup (which would return the FIRST work order associated with
that)
- Have a column, IF LOOKUP = WORK ORDER, 0, 1
- Sort on that 1

But that seems clunky and inaccurate.

Thanks
.

On Apr 7, 11:00*pm, Jacob Skaria
wrote:
Hi

1. Select the Range (say A1:C100). Please note that the cell reference A1
mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting

3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF($A1:$A$1,$A1)1

4. Click Format ButtonPattern and select your color (say Red)

5. Hit OK

PS: If you are using XL2007 Goto Home tabStylesConditional
FormattingManage rulesNew ruleUse a formula to determine which cells to
format. Enter the formula in the box below.

--
Jacob (MVP - Excel)

"RJB" wrote:
I'm working with copies of someone else's SAP files.

Machine operators enter "Notifications" into SAP, which schedulers
turn into "Work Orders".

After the job is complete, there is a row of data for each time anyone
- operator, scheduler, mechanic, etc. - made a change to the record.

Notifications have distinct numbers, as do work orders.

So you may have:

NOTIFICATION | WORK ORDER | ACTIVITY
0001 | 2985 | Notified pump out
0001 | 2985 | Scheduled work
0001 | 2985 | Calibrated pump
0001 | 2985 | Caliper post on first grid armature adjusted to three
0001 | 2985 | Lubed
0001 | 2985 | Closed with comments

A vast majority of the time, ONE notification will lead to ONE AND
ONLY ONE work order. There are SOME notifications that lead to two (or
more) work orders.

I need to find a way to highlight those that lead to two or more.

The best I could come up with was:
- Sort
- Do a lookup (which would return the FIRST work order associated with
that)
- Have a column, IF LOOKUP = WORK ORDER, 0, 1
- Sort on that 1

But that seems clunky and inaccurate.

Thanks
.

Not working....