Excel Tips :- Sort By Colour in Excel 2003

Excel Tips :- Sort By Colour in Excel 2003

 
 
For sorting by cell colour these are the steps

Step # 1
Just Download and open this attached file link is given below :-

DOWNLOAD FILE

Step # 2
Enable macros

Step # 3
Then open the file in which you want to sort by cell colour

Step # 4
Write a simple formula in any cell giving the address of colourd cell (like if you want to sort A column the formula will be)

=GetColor(A1)

you will get some numeric nos. in Desired cell.

Step # 5 just sort out the sheet by those numeric values.

have fun.


If you still have any query, u can email me.

Imp : please note in Excel 2007 this is available in in Sort option itself. no need to download this file if you are using excel 2007. this is only for versions before Excel 2007


Thanks & Best Regards

Praveen
 
Replies (9)

Thanks for sharing

 

Thanks

Dear sir,

We can't open this attachement, plz mail me on r_ajay001 @ yahoo.com

thanks

thanks

Dear Ajay Jee,

Link is ok. you can download it from there.

i m also attaching it again

 

 

 

 

 

 

Sir please clear step no. 5.

Thanks

Dear swohra ,

you need to just select the desired cells and sort by the column which have numeric value.

:-)

 

Originally posted by :swohra

" Sir please clear step no. 5.
Thanks
"


 

thank you

thank for such a gud and useful post.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured ARTICLESHIP 17 November 2026
Associate/ Article Trainee

M/s. A V C & Co.

New Delhi

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
13 November 2026
Accountant

New Mobile India

Muzaffarpur

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details