Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another cell
I have a spreadsheet containing lists of serial numbers. If I enter a serial
number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another cell
If numbers are in column A then apply conditional formatting to column A with
this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
I applied your formula but it didn't work. Have you tried yourself?
"Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
Hi
I tried it and it works this way: Hi started by selecting the range, first cell A1 and then copied the formula in CF, I selected a pattern and its working. HTH John both cells are coloured. "Khoshravan" wrote in message ... I applied your formula but it didn't work. Have you tried yourself? "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
I understand my problem. The sequence of steps in Stefi's solution is
important. You have to define the formula for one cell and then drag the formula down the column. In my way, first I select the range and then applied the formula and it doesn't work. The solution was nice. "John" wrote: Hi I tried it and it works this way: Hi started by selecting the range, first cell A1 and then copied the formula in CF, I selected a pattern and its working. HTH John both cells are coloured. "Khoshravan" wrote in message ... I applied your formula but it didn't work. Have you tried yourself? "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
Could you please explain what is the functionality of COUNTIF(A:A,A1)1? I
know it gives true if the numbers are repeated and give false if they are not equal, but I can't figure out how does it work. "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
It counts the number of A1 values that are in column A - if there are
more than 1 this means there are duplicates. As the formula is applied to the second row the A1 becomes A2, so it counts the number of A2 values in column A. Similarly down the column. Hope this helps. Pete On Feb 2, 6:23*pm, Khoshravan wrote: Could you please explain what is the functionality of COUNTIF(A:A,A1)1? I know it gives true if the numbers are repeated and give false if they are not equal, but I can't figure out how does it work. "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi „john talbot” ezt ķrta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible?- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
Thanks. It was very informative and easy to understand. NG is valuable for
these discussions which could not be found in any MS help menus. "Pete_UK" wrote: It counts the number of A1 values that are in column A - if there are more than 1 this means there are duplicates. As the formula is applied to the second row the A1 becomes A2, so it counts the number of A2 values in column A. Similarly down the column. Hope this helps. Pete On Feb 2, 6:23 pm, Khoshravan wrote: Could you please explain what is the functionality of COUNTIF(A:A,A1)1? I know it gives true if the numbers are repeated and give false if they are not equal, but I can't figure out how does it work. "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible?- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
Well, thanks for feeding back. As I spend a lot of my time on these
NGs, I must agree with you !! <bg Pete On Feb 2, 6:57*pm, Khoshravan wrote: Thanks. It was very informative and easy to understand. NG is valuable for these discussions which could not be found in any MS help menus. |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
This is brilliant! I have a huge database of customer info and this makes it
so simple to find the dupliates!!! Thank you!! "John" wrote: Hi I tried it and it works this way: Hi started by selecting the range, first cell A1 and then copied the formula in CF, I selected a pattern and its working. HTH John both cells are coloured. "Khoshravan" wrote in message ... I applied your formula but it didn't work. Have you tried yourself? "Stefi" wrote: If numbers are in column A then apply conditional formatting to column A with this formula: =COUNTIF(A:A,A1)1 and assign a pattern to it! Regards, Stefi €˛john talbot€¯ ezt Ć*rta: I have a spreadsheet containing lists of serial numbers. If I enter a serial number which already exists in the spreadsheet, I would like the new cell to be highlighted to indicate that the entry already exists - is this possible? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
May I ask you, how much time do you spend in these NG in average?
I know/asked from these Ng's for a long time but recently have got keen interest on them to master my skills as much as I can. I spend hours but I think in case of people like you, it must be more than hours?!? "Pete_UK" wrote: Well, thanks for feeding back. As I spend a lot of my time on these NGs, I must agree with you !! <bg Pete On Feb 2, 6:57 pm, Khoshravan wrote: Thanks. It was very informative and easy to understand. NG is valuable for these discussions which could not be found in any MS help menus. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I auto highlight a cell with the same data as another c
Well, I don't like to tot up the time I spend here - it might make me
feel guilty about not spending the time decorating or on other chores that my wife would like me to do !! <bg Like all things, the more you practise the better you become - I got a banjo for my birthday recently, so I hope to devote some time to learning that (when I'm not on here). Pete On Feb 2, 8:05*pm, Khoshravan wrote: May I ask you, how much time do you spend in these NG in average? I know/asked from these Ng's for a long time but recently have got keen interest on them to master my skills as much as I can. I spend hours but I think in case of people like you, it must be more than hours?!? "Pete_UK" wrote: Well, thanks for feeding back. As I spend a lot of my time on these NGs, I must agree with you !! <bg Pete On Feb 2, 6:57 pm, Khoshravan wrote: Thanks. It was very informative and easy to understand. NG is valuable for these discussions which could not be found in any MS help menus.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
the 'cell' that allows you to automatically highlight all the data (below the name box in the corner) | Excel Discussion (Misc queries) | |||
How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
How can I auto highlight a cell | Excel Worksheet Functions | |||
highlight range if cell contains desired data | New Users to Excel |