I have this formula I'm currently using withing CF to highlight any duplicated rows across three columns...
'=COUNTIFS($D:$D,$D1,$E:$E,$E1,$I:$I,$I1)>1
Is it possible to exclude the highlighting feature on cells in column 'I' that contain the words "TBC, NA or N/A"
any help much appreciated!
Bookmarks