Forum Discussion
Bilosta
Jan 31, 2024Copper Contributor
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 ...
Lorenzo
Jan 31, 2024Silver Contributor
Hi Bilosta
You cannot achieve what you expect with the built-in Cond. Format Highlight Duplicate Values rule. Instead you'll have to setup a custom rule using a formula:
Cond. Format rule that applies to =$E$2:$E$14 for the above example:
=AND($E2 <> "n/a", COUNTIF($E$2:$E$14,$E2) > 1)If not already the case I would recommend you to https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370#:~:text=1%20Select%20any%20cell%20in%20the%20table%20from,displayed%20in%20the%20default%20table%20format.%20See%20More
Corresponding sample is available https://1drv.ms/x/s!AsuqEFbTJNgcgaZujOun6v-L-twScw?e=e25BEz