Solved Conditional Formatting w/ Multiple Criteria

[EzGoingKev]

Good morning.

I have a field that will contain bolt thread specifications. Some cells will be left empty.

They need to be entered like this - M18-2.0. The person populating the data is entering M18-2.

I need to write a formula to ignore the cell if it is blank but if it in not blank but does not have a period in the cell.

 

[Isaac]

They need to be entered like this - M18-2.0. The person populating the data is entering M18-2

ignore the cell if it is blank but if it in not blank but does not have a period in the cell.

I'm not really following you. Can you re-state the requirement somehow more clearly?

 

[EzGoingKev]

OK so if the cell is empty then completely ignore it. Do nothing. No formatting needed.

If the cell is not blank and is missing the period then I want to turn it red.

 

[Isaac]

Ok got it. And I shouldn't be paying attention or inferring anything special from your statement that they need to be entered as " - M18-2.0 ", yet, the person will only be entering "M18-2" ?

 

[EzGoingKev]

Ok got it. And I shouldn't be paying attention or inferring anything special from your statement that they need to be entered as " - M18-2.0 ", yet, the person will only be entering "M18-2" ?

Yes, you can ignore that.

 

[Isaac]

If my last statement is correct, try selecting the top cell in the column where you want this formatting. Go to Conditional Formatting, Manage Rules, New/Create Rule, "Use a formula to determine..."
In the formula, type:

=AND(ISERROR(FIND(".",A1))=TRUE,A1<>"")

Except replace A1 with the cell you selected - that top cell in the column where you want this.

Continue OK or Apply until finished.

Now with that same cell still Selected, put it on Copy. Then select the whole column (or the rest of the cells anyway), and click Paste Special, Formats.

 

[EzGoingKev]

That did it!

You are awesome. I will name my first child after you!

 

[Isaac]

Glad it worked!!