User Profile
Bilosta
Copper Contributor
Joined Jan 30, 2024
User Widgets
Recent Discussions
remove Conditional formatting for specific duplicates,
Hi all, I have situation where I have conditional formatting in column E for duplicates. in column E I need to have unique references but sometimes I do not have any reference for some row, and I need to write N/A (non-applicable). Now Excel highlight me that cells as duplicates, but I do not want that cell to be highlighted. So is there any rule that I can say that excel ignore N/A (or any other reference) as duplicates. thanks.
