I'm trying to apply conditional formatting to a column so that names are always entered "LastName, FirstName". (Last Name, Comma, Space, First Name) I created a conditional formatting rule for the column to turn the text red and and the background yellow if a cell Does Not Contain " , ". (That is a comma followed by a space.) This doesn't work. When I go back to look at the rule, the space after the comma has been discarded. How can I express this in a rule so that "Smith,John" is displayed as " Smith,John", but "Smith, John" does not have its formatting changed? Thanks.

Keith