Results 1 to 3 of 3

highlight entire row base on a single cell value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-29-2008
    Location
    usa
    MS-Off Ver
    EXCEL 2010
    Posts
    116

    highlight entire row base on a single cell value

    Can anybody help me to fix this macro i have it to where is highlighting a single cell i will like the macro to highlight entire row base on a single cell value

    thankyou for any help provided
    Sub colorentirerow()
    'base on a value of single cell highlight entire row
    Range("A1", ActiveCell.SpecialCells(xlLastCell)).Select
    For Each mycell In Selection
    If mycell.Value Like "5" Then
    mycell.Interior.ColorIndex = 3
    End If
    Next
    End Sub
    Last edited by martinez_pedro; 02-12-2010 at 10:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1