Or if you want macro.
![]()
Sub HiLiRow() For Each cl In Selection 'Select which cells you want the macro to run If cl.Value = "NET" Or cl.Value = "RET" Then cl.EntireRow.Interior.Color = RGB(255, 0, 0) End If Next cl End Sub
Or if you want macro.
![]()
Sub HiLiRow() For Each cl In Selection 'Select which cells you want the macro to run If cl.Value = "NET" Or cl.Value = "RET" Then cl.EntireRow.Interior.Color = RGB(255, 0, 0) End If Next cl End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks