Hi,
I need formula for conditional formatting to highlight values which are not exactly matching to name manager range.
It should check cases and spaces also.
I have attached the sheet.
Thanks,
Hi,
I need formula for conditional formatting to highlight values which are not exactly matching to name manager range.
It should check cases and spaces also.
I have attached the sheet.
Thanks,
Replace the current CF with this:
=SUMPRODUCT(--EXACT(A2,Title_Type))=0
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks