• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Highlight the row when two column matches

A

anuwers

Member
Code: 
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Column = 6 Then Target(1, -4).Resize(, 21).Font.ColorIndex = -(Target.Value = "Done") * 3
End Sub

Dear Friends,

Above VBA code is given. But i need little change.

Above CODE states that, if F column find the word "Done", then it changes the color of the fonts for those available in column A till U.

1)I need the below also to be included with the above code.
2)A till U should get highlighted with Yellow color back ground in those cells.
3)Above CODE works only i write "Done", it does not work if i change and write or change upper and lower characters.
4)i required to add one more decision, let us say decision is "NotDone", then VBA to support in highlighting with different color.
5)Above code does look only the F column and change the font color, but i want the code to decide by matching C column word "Hello" to match with F column word "Done", then to be highlighted

Please support
 
What you want can be done using Conditional Formatting (CF) and doesn't require VBA

If you post a sample file we can give a more targeted response
 
You must log in or register to reply here.
Back
Top