hi guys, cant seem to get my head around this formating thing.
a) GZ11:GZ25 contains text
b) look KC11:KC25 and if found duplicating text, highlight it in red
I currently have =GZ11=$KC$11:$KC$25 applied on GZ11:GZ25, does not work... why is that? what is a correct formula pls?
Thanking in advance!
https://www.excelforum.com/attachmen...1&d=1623590185
Bookmarks