Hi Excel professional, J and M columns, the value of any cell is changed, the cells change color as I want TURQUOISE. But I do not know how. What might help, thank you.
Hi Excel professional, J and M columns, the value of any cell is changed, the cells change color as I want TURQUOISE. But I do not know how. What might help, thank you.
Sounds like either conditional formatting (Format>Conditional Formatting), or event code. When you opened the workbook, did it ask to enable macros? Try looking at the sheet code, select the worksheet tab, right-click, and select View Code.
I can not use conditional formatting because the cells in column J and M values are already there. My goal here, I have taken the data automatically to SQL database vendor and unit prices by the amount of manual intervention to be provided. Manually change the first glance that the cells in which I need it to be noticed.
I'm doing research on this subject for a long time. I could not find an example yet, but the overlap exactly. Worksheet_SelectionChange event procedure within a loop should be noticed. But unfortunately I do not know how.
My English is not very good. I am using a translation program. Punctuation is not paying attention to the meaning of disorder can be. If you change a cell. Replacement of the cell. How to automatically change the color of the code should be?
I found the answer, thank you.
Private Sub Worksheet_Change(ByVal Target As Range)
st_row = Target.Row
st_col = Target.Column
If (st_col = 10 Or st_col = 13) and (st_row < 101) Then
If Target = "" Then
Cells(st_row, st_col).Interior.ColorIndex = xlNone
Else
Cells(st_row, st_col).Interior.ColorIndex = 8
End If
End If
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks