LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

Valser

Font color will not affect the alphabetic sorting of a list.

Color, whether it be font or background, is a Format only and does not affect
the underlying value of the data in cells.


Gord Dibben Excel MVP

On Sun, 27 Feb 2005 10:09:03 -0800, Valser
wrote:

None of the Help links answered my question. I need to know if using font
colors prevents me from alphabetizing a list.
My Excel spreadsheet, which is a list of names and addresses, uses several
different colors of font (as a code), and suddenly will not "sort" using Data
- Sort by - Then by (as it always has done with no problem.) Does font color
affect the ability to sort by alphabet in a chosen column?


 
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
Create a cascading list box using Excel JPB Excel Discussion (Misc queries) 1 February 24th 05 08:43 PM
How do I enlarge font in a drop-down list in EXCEL? Stan Excel Discussion (Misc queries) 2 February 21st 05 10:30 PM
how to alphabetize a list in Excel DJ Somers Excel Worksheet Functions 4 January 1st 05 03:39 AM
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 04:07 PM
how to increase the font size in a dropdown list? Sossys Excel Worksheet Functions 2 December 16th 04 01:09 PM


All times are GMT +1. The time now is 01:18 AM.

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

About Us

"It's about Microsoft Excel"