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
|