Spiga

How to sort coloumns or rows by color in excel 2003

Hi.. Friends....
After long time, i am going post an excel tip for
sorting by color. Yesterday when i was working on excel, i got this probelm. Actually this color sorting is available in excel 2007, but not in excel 2003. some times we have to submit different fields data which was completed by you but indicates by different colors. Then we need to sort by those colors. For that i got a small solution.
We have to give formula in first beside coloumn cell what we are going to sort out. Later copy that formula in remain that coloums cells.
Formula:
=colorindex(A1)
This colorindex command gives different index numbers to different colors, so by using those cnumbers we can sort out our data.
All the best...

post your comment below......

0 comments:

Disclaimer

These articles are intended for IT Professionals and systems administrators with experience servicing computer hardware. Please do not attempt any of these procedures if you are unfamiliar with computer hardware, and please use this information responsibly. We are not responsible for the use or misuse of this material, including loss of data, damage to hardware, or personal injury.For videos, games we are not responsible. Thank you.