Results 1 to 5 of 5

Thread: Highlight Cells

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    I have a dropdown box in cell A1 that gives me the choices "A", "B", "C", "D", or "E". What I would like to do is when I select "C", the cells B1:B5 would be highlighted in yellow. Any ideas?
    Thanks in advance.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Use conditional formatting on B1:B5 using the formula:
    =$A$1="C"
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    Use conditional formatting on B1:B5 using the formula:
    =$A$1="C"
    Thanks Rory. Unfortunately, I am having a problem with the attached spreadsheet. Any help?
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What is the problem?

    When I change the drop down, only the first two rows change to the correct color. If I scroll the cells off the page and scroll them back on, all of the cells are colored correctly. The correct colors also appear if I highlight the cells, but with a white border on the left and right sides of the cells in rows 3, 4, and 5.

    I cannot offer a solution, but maybe only confirmation if you are seeing the same behavior.

  5. #5
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If I re-assign the data validation to the A1 cell, all 5 rows change color but with rows 1 and 2 going first then 3, 4, and 5. Weirdness abounds.

Posting Permissions

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