Capital Letters Checks

[Gabriele]

Hi,
I have the following problem:
I need to checks the first capital letter of every word, if it's not i want to fill color of the cell.
Example:

Correct: <Mary Jennifer> <Blige>
Wrong: <mary jennifer>, <MARY JANNIFER>, <mARY jANNIFER>, ...

Putting the following formula the checks value works: =IF(EXACT(B11;PROPER(B11));1;0)
Putting almost the same formula into a conditional formatting it doesn't works:
=EXACT(B11;PROPER(B11))

What's wrong? Is necessary to create a MACRO?
Thanks.

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.