sorting rows based upon formatting

A

ahaigh

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
 
F

Franz Verga

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?
Click to expand...

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
 
A

ahaigh

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
 
J

Jim Cone

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"
<[email protected]>
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
 
Top