Forum Discussion
Astrid Schmidt
Apr 06, 2018Copper Contributor
EXACT function and conditional formatting
Hey there,
I am looking for a solution to combine EXACT and conditional formatting: I need to compare text in two columns and I want to highlight the texts in the second column that have been changed. I used the EXACT function as the texts are case sensitive. I managed to highlight the cells in the second column that are identical by using =EXACT(B1;A1) for the conditional formatting of the second column but I'd rather have it the other way round (highlight the non-matches). Is there a way to do this without adding a third column?
Thanks for your suggestions.
Hi Astrid,
For not-matched you may use NOT(EXACT())
Hi Astrid,
For not-matched you may use NOT(EXACT())
- Astrid SchmidtCopper Contributor
Sergei, thank you ever so much.
You are the good end to an aweful workday :-)