Hi

Hopefully a straightforward question.

I have a worksheet where various rows have been differentiated by
either formatting the values as bold or applying colour to the whole
row.

Is there any way I can sort the rows by the format that has been
applied to them?

I've been trying to work out a way of applying a value based on the
format of the cells but am struggling with it.

Can anyone help?

Thanks


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554889

Nel post
*ahaigh* ha scritto:

Hi

Hopefully a straightforward question.

I have a worksheet where various rows have been differentiated by
either formatting the values as bold or applying colour to the whole
row.

Is there any way I can sort the rows by the format that has been
applied to them?


No way without VBA and also with VBA I'm not sure it could be simple...

Maybe you can add a column in which you can put a value based on your
formatting and then sort with that column.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Franz,

Thanks for your help.

I think you're right that the easiest way is to add a value based on
the formatting. (I'll just have to explain to the person who provided
the data why they need to do that in future.)

I have seen a VBA function online that allows you to sort by colour but
it's probably more trouble than it's worth for the spreadsheet in
question.

Thanks again for your response.

Al


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554889

You could use helper columns with UDFs like =GetColorIndex(A1)

HTH
--
AP

"ahaigh" a écrit dans
le message de news: ...

Franz,

Thanks for your help.

I think you're right that the easiest way is to add a value based on
the formatting. (I'll just have to explain to the person who provided
the data why they need to do that in future.)

I have seen a VBA function online that allows you to sort by colour but
it's probably more trouble than it's worth for the spreadsheet in
question.

Thanks again for your response.

Al


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile:
http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554889

A commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"ahaigh"

wrote in message Hi
Hopefully a straightforward question.
I have a worksheet where various rows have been differentiated by
either formatting the values as bold or applying colour to the whole
row.
Is there any way I can sort the rows by the format that has been
applied to them?
I've been trying to work out a way of applying a value based on the
format of the cells but am struggling with it.

Can anyone help?
Thanks
--
ahaigh

hi Ahaigh

try this module on the Chip person page
http://www.cpearson.com/excel/SortByColor.htm

HTH
Regards from Brazil - going to the 6th *
Marcelo

"ahaigh" escreveu:


Hi

Hopefully a straightforward question.

I have a worksheet where various rows have been differentiated by
either formatting the values as bold or applying colour to the whole
row.

Is there any way I can sort the rows by the format that has been
applied to them?

I've been trying to work out a way of applying a value based on the
format of the cells but am struggling with it.

Can anyone help?

Thanks


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554889