Forum Discussion

Astrid Schmidt's avatar
Astrid Schmidt
Copper Contributor
Apr 06, 2018

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.

    • Astrid Schmidt's avatar
      Astrid Schmidt
      Copper Contributor

      Sergei, thank you ever so much.

      You are the good end to an aweful workday :-)

Resources