Duplicate conditional format
I am looking for the same rule like excel conditional formatting, highlight cell rules duplicate values.
I have employee number row, if the same employee number is entered, would like to highlight the numbers.
Answers
-
You would need a helper column that can be hidden after setting up that will flag duplicates. You would then create your conditional formatting rule based on this helper column being flagged.
-
what is a helper column? Is that mean create another same columns that copy from the main entry then to detect duplicate?
-
It is simply a new column with some type of formula in it to "help" the sheet function the way you want it to. You could use a basic COUNTIFS to count how many times the number appears and then use conditional formatting on rows where the number in the helper column is greater than one.
=COUNTIFS([Number Column]:[Number Column], @cell = [Number Column]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!