+ Reply to Thread
Results 1 to 2 of 2

Excel 2010 IF (Text is a certain colour) THEN ?? Sorting or counting based on text colour

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Excel 2010 IF (Text is a certain colour) THEN ?? Sorting or counting based on text colour

    I have a database of names in one column in excel 2010 and over time I have coloured the text of some of the names green to show that they have been added to a new online database. I want to be able to count how many of the names have been coloured so I can see if it matches with the total number already added on to the online database. I have over 800 entries so I don’t want to have to manually count them unless I find I have missed any. Conditional Formatting is greyed out (it is a Shared document so that might be why).

    Can anyone help me in creating an IF (text is a certain colour) THEN 1, 0… or any others ways I can find the total in that colour. I only have two text colours in my spread sheet, black and light green.

    Thanks

    Example of Table.JPG

  2. #2
    Forum Expert millz's Avatar
    Join Date
    08-14-2013
    Location
    Singapore
    MS-Off Ver
    Excel, Access 2016
    Posts
    1,694

    Re: Excel 2010 IF (Text is a certain colour) THEN ?? Sorting or counting based on text col

    You can use filter by color. Highlight your column, click on Data -> Filter, on the header name click on the filtering arrow, Filter by color -> and click the light green. Then highlight the cells that are filtered out, by default there should be a "Count" on Excel's status bar. If it's not there, right click on Excel's status bar and enable "Count".

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 11-29-2012, 11:27 AM
  2. [SOLVED] Macro to change text colour of adjacent cell to the same text colour as target cell
    By kayoke in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-28-2012, 04:18 AM
  3. Replies: 2
    Last Post: 06-07-2011, 07:00 AM
  4. How to make row change colour based on text colour in row?
    By Joanna13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2010, 04:39 PM
  5. [SOLVED] Sorting by text colour
    By Mark Fox in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2005, 03:05 PM

Tags for this Thread

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