Consulting

Results 1 to 9 of 9

Thread: If cell = [Word], hilight row

  1. #1

    If cell = [Word], hilight row

    Hello.
    What i am wanting to do is this:
    If A1 = [Word] then it will highlight the whole cell.
    Would that be hard

  2. #2
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Select cell A1
    Then, On the main toolbar select format

    then select conditional format

    Condition 1
    first window.....second window.....third window
    Cell value is......equal to .............="word"
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  3. #3
    it only highlights the selected cell...

    Cell value = word displays with yellow fill, but its only that 1 cell not the row

  4. #4
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    select the cell.

    hover over it's lower right hand corner and when you get an + left click and hold and drag it to whatever cells you want.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  5. #5
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    You can also copy and paste the formatting
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  6. #6
    Okay with that tho, there is going to be other text in the other cells that doesnt match the word, it is for a stat sheet

    so one cell might be a name, the other cell a number etc.

  7. #7
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    select each cell one at a time and treat it just as you did A1 except use the other text instead of

    ="word"

    use

    ="otherword"

    read the help file. You can use numbers and you can use formula's such as if the number is larger than or equal to etc.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  8. #8
    the thing is tho as it is a stat sheet, there could be 50 different names on that.
    on the net someone said this, dunno if it helps.

    Range("A" & Target.Row, Target.EntireRow)
    Last edited by Aussiebear; 04-13-2023 at 01:40 PM. Reason: Added code tags

  9. #9
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    post an example of your data..

    on one sheet show your data as it is and on another sheet format some of it the way you want it so we can look at it with you.

    We are getting no where fast this way.

    click the post reply button at the bottom left of the last post and then scroll down and look for a button that says manage attachments.

    You've gone from asking about formatting one cell to using code for a row which is a little different.

    remember, asking the right question is half of solving a problem and we can't see over your shoulder.
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

Posting Permissions

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