Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: STREAMLINED CODE TO HIGHLIGHT OR UNHIGHLIGHT A RANGE

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    OKC
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I currently used some clunky code that was written some years ago and I know there is a more streamlined way to do it....... i have a worksheet where is number greater than 1 is placed in a cell in a range, lets say, b2:b25 ,which causes the activecell (b2) and seven cells to the right to unhighlight. I need simpler code that will do this, as well as highlight the seven cells to the right if the number in B2 is deleted (blank cell)

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you just use conditional formating to make the cells look the way you want based on the formula you choose? For example you could conditionally format cells c1:c10 to be highlighted if the formula =isblank(b2)='Y' is true.


  3. #3
    Board Regular sen_edp's Avatar
    Join Date
    Mar 2002
    Location
    Hellas
    Posts
    555
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    HELLO

    I AGREE

    USE CONDITIONAL FORMATTING, IT IS NICE, AND NO VBA CODE NEEDED.

    RGDS

    ANDREAS

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    OKC
    Posts
    98
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks, you're right, all the clunky code was replaced by conditional formatting.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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