Conditional Format

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
Select columns A:C for the data, starting at A1
Menu Format>Conditional 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)
 
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?
 
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)
 
Nothing at all happened Bob :(

Bob said:
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)
Click to expand...
 
Back
Top