Results 1 to 3 of 3

Thread: Using "IF" statement to count number of highlighted or colored font cells

  1. #1
    Neophyte msorange's Avatar
    Join Date
    Feb 2015
    Location
    Columbus, OH
    Posts
    4
    Articles
    0

    Question Using "IF" statement to count number of highlighted or colored font cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    Is this even possible?? Maybe I could append a unique identifier, one for the highlighted cells, and one for the colored font cells, then I could count the cells easier. I hate using color and highlighting in spreadsheets this way. The spreadsheet I am working with is very wide, about 430 columns, so I am trying to get rid of the cells I don't need to make the table work better for me. Any and all suggestions are greatly appreciated!


    Kelly
    Attached Files Attached Files

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by msorange View Post
    Any and all suggestions are greatly appreciated!
    I have idea for count cell color. See attachment
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by navic View Post
    I have idea for count cell color. See attachment
    Assuming that coloured fonts are those apart from black, you could do a CF for this as well?

Tags for this Thread

Posting Permissions

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