Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional formatting (2000)

    Hello all,

    I just cannot think of a way to do this. Let's suppose that cell A1 has the value "bla" in it. Now in B1 I have the conditional format that says if B1=A1 then the background color of B1 is yellow. That is simple enough, here is the kicker, I want to make C1,D1 and E1 all have yellow backgrounds if B1 is a yellow background and I would like to do it without using any vba. If this is possible fantastic, if not, I need the vb code that can do it but extended to various rows. In other words, if B2 = A1 then all B2 C2 D2 E2 become yellow, if B3=A1 then all B3 C3 D3 E3 become yellow ect.

    thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional formatting (2000)

    Select as many rows in columns B:E as you want to format.
    Select Format | Conditional Formatting...
    In the first dropdown list, select Formula Is
    In the box to the right of it, enter =$B1=$A$1
    It is essential here that all references are absolute ($) except for the row number 1 in $B1. This makes the row number relative, so that it will adapt itself for subsequent rows.
    Click Format... and select a background color you like.
    Click OK twice.

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2000)

    Select B2, C2, D2 and E2 and apply conditional formatting based on Formula Is as opposed to Cell Value is. See th eattached graphic,

    If you apply that formatting to row 2, you can copy those cells and paste special formats to any other rows requiring formatting.

    Andrew C.

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional formatting (2000)

    guys, this worked awsome. Thanks alot

Posting Permissions

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