Conditional Formating based on a list of special characters

Excel Version 2013/2016

I used a PowerShell Script to extract from a folder structure all folder names, filenames, and subfolders. Then I broke that into multiple columns. C to F are the ones I'm concerned about. These particular folders cannot contain a list of special characters. i.e. #, $, ', ", %, ., etc. One thing that makes it difficult is I have to search for periods. Not periods can be in the file or folder names other than the period before the file extension.

I think I need 2 conditional formatting rules, one that uses the list of special characters and another that looks for periods in file and folder names that don't belong.

To give you an idea of the second issue with the periods.

Folder names:
Arch. Rev. 2 06-03-17

Filenames
Arch. Drawing No. 03.pdf

Thank you

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here you go. It's the exact file I already set some conditional formating, but I'm having trouble with the one I mention.

You can turn all those off if you need too. Also I didn't input a list of symbols yet, but pretty much anything other than what's in tis blog post that says OK TO USE
http://www.asti.com/Blog/PostId/2075...-bim-360-field

Why does the Rule with "=SEARCH(".",C2)<>LEN(C2)-3" in it work through out the Cells? Everytime I view the conditional formating on a cell that's the formula that's in it, but it works.

Nevermind I think I have it now, still working on the formatting

One more question, I'd like to search the range and locate all extra periods, not to include the period right before the file extensions. I was able to build a formula that works for the other characters, but with the periods, it's find all of them.

=SUMPRODUCT(LEN($B$21:$AA$200001)-LEN(SUBSTITUTE($B$21:$AA$200001,B3,"")))

Just not sure how to make it not see those periods that need to be there.

JeteMc,

My apologies. When I said I wanted to find them I meant I wanted to count them. See my current verision. In Cell A2 I want to have a formula that will find and count the extra periods.