Hi Everyone,
Could anyone help me with a macro that will run the scenario below?
• Highlight rows with the letters JZK in Column E and has a percentage over 0% in column L
o The highlight should only run from column A to L.
Hi Everyone,
Could anyone help me with a macro that will run the scenario below?
• Highlight rows with the letters JZK in Column E and has a percentage over 0% in column L
o The highlight should only run from column A to L.
Try this:
![]()
Option Explicit Sub svinet() Dim lr As Long Dim i As Long lr = Range("A" & Rows.Count).End(xlUp).Row For i = 1 To lr If Range("E" & i) = "JZK" And Range("L" & i) > 0 Then Range("A" & i & ":L" & i).Interior.ColorIndex = 6 End If Next i End Sub
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
That worked perfect, Thank you!!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks