Hello,
I made a sheet named Room List. In this sheet. I have 4 columns. In column D, I have numbers 1,2,3,4,5,6,7,8,9 in cells D2, D3, D4, D5, D6, D7, D8, D9, D10 respectively.
In column B, if I write any number, it should be highlighted by color in relative cell of column D.
Example: If I write number 5 in cell B2 of column B, a cell D6 should be highlighted by a different color because D6 contains number 5 which I wrote in cell B2.
Can I do that please? It will be great help to me if I will get response to this at the earliest.
Configuration: MS EXCEL 2007
Right click the sheet TAB and lcick VIEWCODE. in that window copy paste this code
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cfind As Range
Range("d1:d9").Interior.ColorIndex = xlNone
If Target.Address <> "$B$2" Then Exit Sub
With Range("d1:d10")
Set cfind = .Cells.Find(what:=Target.Value, lookat:=xlWhole)
If Not cfind Is Nothing Then cfind.Interior.ColorIndex = 3
End With
End Sub
now type any number in B2 and see what happen in column D |
B&d cad 4 troubleshooting B.static.ak.facebook.com Compare column a to column b Comparing excel column values = true/false D-link ip address Excel how to find max value of a column based on the value of another column Excel combining values in many columns into 1 column Excel spreadsheet column multiplied by value Extract a list of unique values in two columns in excel Find first value in column, find second value Highlight columns for duplicates in excel using vba How to find different values in two excel columns Insert values into table where one column is constant and other changes Return the values of the same values in different columns excel Sorting column a by column d Vba determin row and column of value in range Vba determine if value in column Vba find row and column of value in range