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,410
    Likes Received:
    775
    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:
    5
    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! Oberheim Matrix 1000 Parameter question Samplers, Synthesizers Saturday at 1:38 PM
I need help with nebula 4 not opening right PC Apr 5, 2026
I need some help with Dillon Bastan M4L devices Live Apr 4, 2026
Need help, STL vsts Software Mar 4, 2026
Need help with Waves Ultimate V16 V.R. Sister Site (installation failed) Software Feb 13, 2026
Loading...