Hi folks, i'm wondering whether you can apply case sensitivity in conditional formatting, worth noting that i'm a bit of an excel rookie so don;t understand many of the functions.

For example, i'd like the exact word "mun" to come up in red, but the exact word "MUN" to come up in amber. Is there any way to get the case sensitivity to recognise the difference between the two?

I'm using the 2010 version of Excel.

Cheers,
KEP