Need help with microsoft excel formula

Discussion in 'Lounge' started by samsome, Sep 24, 2021.

  1. samsome

    samsome Guest

    i have a list of words all are below each other 1 by 1

    i need all words that contain more than 2 a's to be highlighted

    anyone knows how to do it
     
    samsome, Sep 24, 2021
    1
  2. Ads Master

    Ads Master

     
  3. Chichan

    Chichan Member

    Joined:
    Aug 23, 2021
    Messages:
    21
    Likes Received:
    16
    Best Answer
    Sure, this will do it....

    The list of words you mention sound like they are in a column. Highlight the cells in this column that you wish to process and make a note of the location of the top most cell - let's assume it is A1.

    On the excel home tab select Conditional Formatting > Highlight Cells Rules > More Rules and select "Use a formula to determine which cells to format. Enter this formula =IF((LEN(A1)-LEN(SUBSTITUTE(A1,"a","")))>2,TRUE,FALSE). Click the format button to choose the type of formatting you wish to use and then click OK to apply.
     
    Chichan, Sep 24, 2021
    2
  4. samsome

    samsome Guest

    thanks! :D
     
    samsome, Sep 24, 2021
    3
  5. orbitbooster

    orbitbooster Audiosexual

    Joined:
    Jan 8, 2018
    Messages:
    968
    Likes Received:
    559
    In past I used a lot to code VBA for Excel, but for some unknown reason now I cannot install developer plugin so I cannot try a macro.
    "Debugging".
     
    orbitbooster, Sep 24, 2021
    4
Loading...
Similar Threads - Need help microsoft Forum Date
Need help, Studio One Filter/Select by Name Script Studio One Wednesday at 11:58 PM
UAD vs Arturia - help needed Software Apr 9, 2024
Roland SRX PIANO. Need Help. How to eliminate hammer' "puff" noise ? Software Apr 5, 2024
Need help deciding which B&W left/right speaker to go with B&W HTM71 S2 center channel Music Mar 12, 2024
Need help finding 2 old sample packs Samplers, Synthesizers Feb 29, 2024
Loading...