Conditional Format
 

I have created a list of drivers with dates they have travelled and
where they have fueled up. I want the spreadheet to flag up if the
drivers have fuelled up more than once in a day in red say.

e.g.
Date Location Driver
17/10/06 London John
17/10/06 London Robert
18/10/06 Southend John
19/10/06 London John*
19/10/06 Southend Robert
19/10/06 London John*
19/10/06 Northampton Graham

Conditional Format
 

Select columns A:C for the data, starting at A1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =SUMPRODUCT(--($A$1:$A$100=$A1),--($B$1:$B$100=$B1))1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I have created a list of drivers with dates they have travelled and
where they have fueled up. I want the spreadheet to flag up if the
drivers have fuelled up more than once in a day in red say.

e.g.
Date Location Driver
17/10/06 London John
17/10/06 London Robert
18/10/06 Southend John
19/10/06 London John*
19/10/06 Southend Robert
19/10/06 London John*
19/10/06 Northampton Graham

Conditional Format
 

Bob this dosen't seem to work for me, froget the location column for
now, I just want to know if the drivers have fueled up more than once
in a day?

Bob Phillips wrote:

Select columns A:C for the data, starting at A1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =SUMPRODUCT(--($A$1:$A$100=$A1),--($B$1:$B$100=$B1))1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I have created a list of drivers with dates they have travelled and
where they have fueled up. I want the spreadheet to flag up if the
drivers have fuelled up more than once in a day in red say.

e.g.
Date Location Driver
17/10/06 London John
17/10/06 London Robert
18/10/06 Southend John
19/10/06 London John*
19/10/06 Southend Robert
19/10/06 London John*
19/10/06 Northampton Graham

Conditional Format
 

I did ignore the location.

What happened when you tried? Any differences in the actual data from what
you showed in the example?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
Bob this dosen't seem to work for me, froget the location column for
now, I just want to know if the drivers have fueled up more than once
in a day?

Bob Phillips wrote:

Select columns A:C for the data, starting at A1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =SUMPRODUCT(--($A$1:$A$100=$A1),--($B$1:$B$100=$B1))1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I have created a list of drivers with dates they have travelled and
where they have fueled up. I want the spreadheet to flag up if the
drivers have fuelled up more than once in a day in red say.

e.g.
Date Location Driver
17/10/06 London John
17/10/06 London Robert
18/10/06 Southend John
19/10/06 London John*
19/10/06 Southend Robert
19/10/06 London John*
19/10/06 Northampton Graham

Conditional Format
 

Nothing at all happened Bob :(

Bob Phillips wrote:

I did ignore the location.

What happened when you tried? Any differences in the actual data from what
you showed in the example?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
Bob this dosen't seem to work for me, froget the location column for
now, I just want to know if the drivers have fueled up more than once
in a day?

Bob Phillips wrote:

Select columns A:C for the data, starting at A1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =SUMPRODUCT(--($A$1:$A$100=$A1),--($B$1:$B$100=$B1))1
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Dave" wrote in message
ups.com...
I have created a list of drivers with dates they have travelled and
where they have fueled up. I want the spreadheet to flag up if the
drivers have fuelled up more than once in a day in red say.

e.g.
Date Location Driver
17/10/06 London John
17/10/06 London Robert
18/10/06 Southend John
19/10/06 London John*
19/10/06 Southend Robert
19/10/06 London John*
19/10/06 Northampton Graham