Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
Conditional Format | Excel Discussion (Misc queries) | |||
Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions |