Excel Sorting

[Justijb]

Hello All,

I can't believe the response and how helpful everyone was last time. Hopefully I can get the same results this time around. Okay - I have a spreadsheet with multiple columns (A through N). How would one go about writing the macro to sort on column D where row 1 is "family name" and I would need to highlight yellow every row that has only one name in it.

E.g.

Rows two and three have 'regina" and nothing else while rows 4-23 has "Elizabeth lastname" and other rows have three names in it.

Is there any way to codify this action by space between words. I'm thinking this is the only way since every name is unique and multiple rows have the same name sometimes?

If further information is needed, please let me know.

Thanks.

V/r


JB

 

[BQardi]

A conditional formatting would probably be the best and easiest way:
Select the range (D:D) to format.
Go to "Conditional formatting" -> "New Rule..." -> "Use a formula to determine which cell to format"
In the TextBox ("Format values where this formula is true:") put this formula in: "=ISERROR(FIND(" ",$A1))"
Push the "Format..." button
"Fill" -tab -> choose color (in your case, yellow)
"Ok" -> "Ok"

Now, if a cell in above range doesn't have a space (" ") in it, this cell will be colored with the color chosen from the "Fill" -tab...