tags:

views:

5

answers:

1
Q: 

can a conditional format insert a comment if there is a duplicate cell in a column?

can a conditional format insert a comment if there is a duplicate cell in a column? If any cell in column "A" is a duplucate, then I want the cell highlighted to color blue and the comment to say "duplicate part_ID". please advise and provide me with complete code for me to copy and paste and instructions. thank you very much, Nathaniel

A: 

Comments cannot be added, but an adjacent cell could house a warning message that is visible or not based on the condition.

guitarthrower  2010-09-30 19:32:26

related questions

Setting a cell's format using Excel 2007 Interop and C#
Where should I post my python code?
excel: charting with unknown number of data
Read specific Coloumns from Excel files with C#
add decimal as time
How to display .net automation add-in functions in excel's formula autocomplete
Excel formula to refrence 'CELL TO THE LEFT'
Problems Reading a .xlsx file?
VBA code for SUMIFS?
Accessing Excel 2007 Binary (.xlsb) via OleDb ACE
How can I permanently prevent Excel from setting all new documents to R1C1 mode?
How do get the index of a table's column by using a structured reference in excel?
Can I make a structured reference absolute in excel 07?
Excel countif Pulling apart a cell to do different things
Upgrade from Excel 2003 to 2007 results in "stack overflow error" on previously working vba
System.Windows.Forms.ToolStrip height or autosize
VSTO problem - cannot create visual studio excel workbook project
Round function in Excel, worksheet function vs VBA
Reliable real values generator for Excel for Office 2007 and Vista SP1
Create an Excel workbook on a x64 system
How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
How do I send an alert to a blackberry from an Excel 2007 spreadsheet?
How to convert a column number (eg. 127) into an excel column (eg. AA)
How do I create an Excel chart that pulls data from multiple sheets?
VSTO Excel 2007 PivotTable, having a PivotField in more than one column