Results 1 to 6 of 6

Issue with sorting data on conditional formatting/font color

Threaded View

  1. #1
    Registered User
    Join Date
    04-28-2013
    Location
    Stockholm
    MS-Off Ver
    Excel 2007
    Posts
    93

    Issue with sorting data on conditional formatting/font color

    Dear all,

    I work with some stock index data and I would like to get rid of some dots and empty spaces etc. I used conditional formatting and changed the font color of all the values I need. When I try to sort them based on font color (in order to delete the empty spaces/dots) Excel does not do it. "Go to...conditional formatting" also doesn't work. Any ideas?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting - change font color in B25 if a separate box B23 says N/A
    By H57 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-24-2013, 04:49 AM
  2. [SOLVED] Conditional formatting to adapt font color to background color
    By jankee in forum Excel General
    Replies: 4
    Last Post: 08-23-2013, 09:38 AM
  3. Replies: 6
    Last Post: 03-20-2012, 12:08 AM
  4. Conditional Formatting of Font Color based on Values in another cell
    By dpcp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2012, 07:49 PM
  5. Font color conditional formatting
    By windme in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-05-2008, 02:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1