Highlight cells based on other cells value

**handydad** · 02-10-2012, 02:25 AM

I need to find out how to highlight a cell (say G34) if cell B34's value is between 70 and 77. I am needing to do this for the entire row of 34 depending on the value of B34. Another example would be to highlight M34 if the value in B34 is between 115 and 122(I could round up or down if need be)
Here is a picture of an example:http://i214.photobucket.com/albums/c...BellCurve1.jpg Bell Curve1.jpg

**john55** · 02-10-2012, 02:48 AM

hi,
try this, make changes for yr needs and see if it helps you

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("A1").Value < 77 And Range("A1").Value > 70 Then
        [a2].EntireRow.Interior.ColorIndex = 4  
    Else
    [a2].EntireRow.Interior.ColorIndex = xlNone
    End If
End Sub

'if you need to color just a cell modify it as [a2].Interior.ColorIndex = 4

**Fotis1991** · 02-10-2012, 02:54 AM

Hi and welcome to the forum.

You can do this, using Conditional Format.

Format>>Conditional Format>>Formula is:

=AND(B34>=115,B34<=122) >> Choose color>>OK.

Hope to helps you.

**A picture does not help us.

Thread: Highlight cells based on other cells value

Thread Tools

Display

Highlight cells based on other cells value

Re: Highlight cells based on other cells value

Re: Highlight cells based on other cells value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions