Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default How do I explan color choices in sort?

I am sorting rows based on the cell colors (which are all a result of
conditional formatting) in one column. This was working just fine, but
suddenly it stopped working. When I tried to fix it, I noticed that it
wasn't giving me the option to chose the cell colors that I needed (all of
which appear in my data)! How can I get those cell color choices back? I
tried giving some of the cells in the range those colors (not by conditional
formatting), but still the colors are not available to choose for sorting.

I will note that this stopped working very soon after I ran an add-in
suggested in this forum (FindLinkZip v 9.2 by Bill Manville on the OA
Website). Also, I am working in Excell 2007.

I appreciate any help you can give!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort choices in filter in pivot table Bob Excel Discussion (Misc queries) 1 May 14th 08 05:22 PM
How do I add another color to the choices in Excel (I need orange lynyantz Excel Discussion (Misc queries) 1 August 2nd 06 04:29 PM
Excel sort by Fill Color by custom list sort Dash4Cash Excel Discussion (Misc queries) 2 July 29th 05 10:45 PM
Autofil color to a row from dropdown list choices Alesia Excel Worksheet Functions 1 March 4th 05 11:57 PM
Changing Fill color choices Steven Excel Discussion (Misc queries) 4 March 2nd 05 04:05 AM


All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"