Sorting of odds and even numbers

[farasatbalooch]

I want to sort odds and even numbers in a list of 5 numbers combination what is formula and how to apply it.

My list Example
5-16-9-21-44
34-22-28-41-39
6-12-18-29-45
11-15-34-32-43
28-27-44-49-47

How to sort odds and even number in this type of list.

 

[Rick Rothstein]

I want to sort odds and even numbers in a list of 5 numbers combination what is formula and how to apply it.

My list Example
5-16-9-21-44
34-22-28-41-39
6-12-18-29-45
11-15-34-32-43
28-27-44-49-47

How to sort odds and even number in this type of list.

It would help if you showed us the output you want from those examples.

 

[farasatbalooch]

It would help if you showed us the output you want from those examples.

It would help if you showed us the output you want from those exampl

It would help if you showed us the output you want from those examples.

I want to highlight odds numbers or even numbers in my list I have around 2 million combinations in my list and I want to highlight the odds number or even numbers in the combination list

 

[Rick Rothstein]

I want to highlight odds numbers or even numbers in my list I have around 2 million combinations in my list and I want to highlight the odds number or even numbers in the combination list

Do you mean for this...

5-16-9-21-44

you want to highlight the individual numbers 5, 9 and 21 (if highlighting odd numbers) within the text itself? Highlight how... bold, different color, something else?

 

[farasatbalooch]

Do you mean for this...

5-16-9-21-44

you want to highlight the individual numbers 5, 9 and 21 (if highlighting odd numbers) within the text itself? Highlight how... bold, different color, something else?

Yes I want to highlight like this is it possible in ms excel 2013?

 

[Rick Rothstein]

Yes I want to highlight like this is it possible in ms excel 2013?

Would a VBA macro be acceptable (I cannot think of any other way to do it)? If so, how are you wanting to highlight the odd numbers and how are you wanting to highlight the even numbers... with colors (if so, which colors)?

 

[farasatbalooch]

Would a VBA macro be acceptable (I cannot think of any other way to do it)? If so, how are you wanting to highlight the odd numbers and how are you wanting to highlight the even numbers... with colors (if so, which colors)?

I want to odd numbers in blue and even numbers in green

 

[farasatbalooch]

I want to odd numbers in blue and even numbers in green

Yes if you know any VBA code to do this with my list so it will be a great help sir I don't know how to write a VBA code for that can you please tell me the VBA code

 

[Rick Rothstein]

Okay, but I cannot work on it right now as I am off shortly to an out of town doctor appointment... I'll look at your problem when I return.

 

[farasatbalooch]

Okay, but I cannot work on it right now as I am off shortly to an out of town doctor appointment... I'll look at your problem when I return.

Ok sir no problem I will be your thankful if you help me thanks sir