IF function for change colour of row based on cell value

[hotdogs1999]

Hello All,

looking for IF function that will highlight a full row if the cell in that row in column L contains the phrase "Complete"

thanks in advance

 

[Michael M]

Can't be done with a native function.
You will need to either create a Conditional format rule OR Use VBA

 

[hotdogs1999]

thats fine. ok to do it any way that works.

would prefer CF to VBA if possible.

 

[My Aswer Is This]

Hello All,

looking for IF function that will highlight a full row if the cell in that row in column L contains the phrase "Complete"

thanks in advance

Is this part of the same thing I answered for you about moving rows.

These two things could be done with the script I provided for you.
But in your previous post you said complete in column G

And define highlight

 

[hotdogs1999]

yes, this actually does have to do with the same thing.

sorry for the confusion, G was hypothetical. i just adjusted it to the appropriate column when i inserted it.

 

[My Aswer Is This]

Well I'm confused now do you need more help

Are you saying the script I wrote you worked but now you want the rows highlighted.
And does that mean make row interior color Green.

 

[hotdogs1999]

sorry for the confusion.

so i need to move entire row to bottom of active sheet when cell in specific column (e.g. G) contains "complete", and when it is moved change the fill colour of the entire row to green.

does that make sense?

 

[My Aswer Is This]

Try this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G:G")) Is Nothing Then
'Modified  12/13/2018  11:09:22 PM  EST
If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub
Dim Lastrow As Long
Dim r As Long
r = Target.Row
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
If Target.Value = "complete" Then
    
Rows(r).Interior.ColorIndex = 4
    
    Rows(r).Copy Rows(Lastrow + 1)
    
    Rows(r).Delete
End If
End If
End Sub

 

[hotdogs1999]

thanks. works great