Conditional formatting for a duplicated #

steve50951

I want to turn a cell red when the # in that cell is a duplicated #. IOW when the # entered has already been entered in a previous cell in that column, I want to turn that cell red. 

Does anybody know how I could write a conditional formatting rule that would work to accomplish this. 

 

thanks, 

 

SGF

Shaine Greenwood

Hi SGF,

I found a few other community posts where people have asked this or similar questions before:

• https://community.smartsheet.com/discussion/conditional-formatting-duplicates
• https://community.smartsheet.com/discussion/zapier-and-duplicates
• https://community.smartsheet.com/discussion/identifying-duplicates-within-column