Entry list of candidates in the EXCEL spreadsheet, to enter the phone number, if discovery has input the number, automatically remind the phone number has been input, then prompt next (to continue or cancel the operation, the function of the how to write? At the phone number column, data - data validity set=COUNTIF (C, C, C1)=1 function, manually enter the repeat number, enter when can remind, but if it is copy and paste to the cell's data, cannot achieve reminds, excuse me, if it is copy and paste to the data, can realize repeatedly remind?
Ask everybody to help, thank you!

CodePudding user response:

Repeat the phone number of the form automatically mark the other colors, so can also, this is should use macros to implement

CodePudding user response:

Select the phone number in the column, in the "start - conditional formatting rules - - highlighted cell duplicates" menu, to duplicate values set the fill color, has realized, thank you for your attention!

CodePudding user response:

Think of can be used "conditional formatting" implementation, but don't know that high version can be used directly in the preset item; From the old version, and master the knowledge of new function, also is not a simple thing,

CodePudding user response:

Choose a phone number that a column, then click on the title bar of the start, in the selection criteria format - highlighted cell specification - duplicate values - select custom formatting or the default format, click on the confirmation, back to the same input in this column will be displayed in the conditional formatting you set,

CodePudding user response:

Learned! Thank the building Lord!

CodePudding user response:

With so much! Thanks for!