EXACT function and conditional formatting

[Astrid Schmidt]

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.

[#2 · Accepted solution]

Hi Astrid,

For not-matched you may use NOT(EXACT())

[#3]

Sergei, thank you ever so much.

You are the good end to an aweful workday :)