Conditional formatting to highlight row if cell x contains......

[Linsie]

Hi,

I have been staring at my spreadsheets all day and now my brain is refusing to work.

I am trying to get a formula that will highlight rows where cell K contains a specific word.

For example - highlight row if cell K contains the word complete.

It only needs to search for the text in K but needs to highlight all the rows that contains "complete" in that column".

Does that make sense?

Thanks in advance for any help.</SPAN>

 

[mumps]

Try:

Option Compare Text
Sub Test()
    Dim bottomK As Integer
    bottomK = Range("K" & Rows.Count).End(xlUp).Row
    Dim c As Range
        For Each c In Range("K2:K" & bottomK) 'Assumes that there is a column title in K1
            If c = "Complete" Then
                c.EntireRow.Interior.Color = 255
            End If
        Next c
End Sub

 

[Linsie]

Thanks but was looking for a formula for conditional format as I am not good with macros.

 

[Smitty]

Welcome to the Board!

You can use the CF Formula option. Just select the entire range you want highlighted, then:

=$K1="Complete"

Format as desired.

HTH,

 

[Linsie]

Thanks Smitty, that worked. Its always the simplest of ones i over think.