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,440
    Likes Received:
    791
    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:
    6
    Likes Received:
    1
    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
Need help with installing GetGood Drums library Software Jun 2, 2026
Please help, batchprocessor badly needed Software Jun 1, 2026
Need help with Toontrack Ezdrummer! Software May 31, 2026
[Solved] Ivoschi MidiBro v1.7.0 help needed Software May 20, 2026
Kontakt help needed Kontakt Apr 26, 2026
Loading...