Find ALL CAPS, convert to lower case

My instinct is this needs to be scripted. It's easy enough to use GREP to find these words, but changing the case to "normal" has no effect, as far as I can tell. You need to change to Sentence Case, and that isn't an option in Find/Change. You also run some risk of changing things you don't want changed, like state abbreviations and other acronyms.

In fact, Harbs has already written a short script that does this. You'll find it in the comments on theis page: http://indesignsecrets.com/using-grep-to-make-a-character-lowercase.php

You'll also find some more discussion at http://forums.adobe.com/thread/329167

Did you read the link Peter provided?

The script I wrote there should do what you want.

If you want a GREP which will not get states for sure, you can use 

\u{3,}

But of course it will miss ANY two letter all-cap word...

Harbs

As was pointed out, the only way to access the change case commands (which is waht you want to do) is through a script interface. You simply can't do it with a Find/Change. You CAN set the search parameters, though, and then run the script that Harbs so generously posted. I'm sure if you post on the scripting forum, someone would probably be willing to also help you with adding a list of states and acronyms you know you don't want to change, or perhaps adding a pause for confirmation at each hit.

This is just too complex to have an simple all or nothing solution since there are always likely to be workd you actually DO want to have as all caps (but maybe if you add a character style to those that forces all caps, you'd get away with changing everything after all).

We've already pointed you in the direction of a solution. If you've used styles (as you should) there's a good chance you can limit the GREP search parameters using styles and or limited search (story, selection) to eliminate a lot of the false positives you might otherwise see.

If you don't wnat to try what's offered, that's another story.

Some people see only problems, others see solutions.

Harb, sort of along the same lines, but not exactly. I am looking for the code (if it exists) to find where the ALL CAPS style has been applied (i.e. Command+Shift+K). Your GREP code is doing a good job at catching where someone typed multiple CAPS in a row, but not if someone types lowercase and then applies ALL CAPS.

I have your GREP set up in the paragraph style, and it activates a character style to flag the text as pink text, and it is working well on everything but the ALL CAPS style.

What do you want to do when you find the text to which All Caps is applied?

Since this text is really lowercase, with the All Caps attribute added, there's probably not a lot that can be done with GREP styles that you would want to do, since it would affect all lowercase text with that paragraph style (and as before, a character style that sets the case to Normal does nothing here).