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:
    1,270
    Likes Received:
    700
    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
  6. Sowrepsia

    Sowrepsia Newbie

    Joined:
    Aug 7, 2024
    Messages:
    3
    Likes Received:
    0
    I know it's been a while, but I get how tricky Excel formulas can be sometimes. I’ve had my share of confusion with them, too. If you’re looking for a straightforward way to tackle this, I suggest checking out excel online. It’s super user-friendly and offers handy templates that might help clear things up. Plus, you can find many tutorials and tips that break things down step by step.
    When I was learning, playing around with the formulas was helpful. Don’t be afraid to experiment! If you mess something up, just hit the undo button.
     
    Last edited: Aug 13, 2024
    Sowrepsia, Aug 7, 2024
    5
Loading...
Similar Threads - Need help microsoft Forum Date
I need help with installing pro tools Pro Tools Yesterday at 9:22 AM
Closed: Stem Sep & Vocal Tuning Help Needed! Mixing and Mastering Jul 24, 2025
Need Help: Best Way to Remove Viruses from My PC? Software Jul 14, 2025
New On Mac, need help please Mac / Hackintosh Jun 12, 2025
Need Help for Midi File Time Signature Working with Sound May 26, 2025
Loading...