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
|