Highlight Rows if more than 2 columns are entered

[nehachoubey]

Hi,
I have to highlight those rows in my excel sheet which have more than 2 columns among 3(C,D and F) entered. Plz help !!

 

[Legacy 234512]

It's called Conditional Formatting what you are looking for.
Another way - if you can use a spare column then enter =IF(AND(A1,C1,D1,F1)<>"",1,"") in f.e. column G then if they are not empty then you get number 1 in that column ( drag the formula down to last row )
Or... vba code ( highlights your cells only if they (A,C,D,F) are all not empty
You can very easily edit this to match your criteria 100%

Option Explicit


Sub highlight()
    Dim iter As Long
    ' if you have a header than change 1 to 2
    For iter = 1 To ActiveWorkbook.ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
        If ActiveWorkbook.ActiveSheet.Cells(iter, "A").Value <> "" And _
            ActiveWorkbook.ActiveSheet.Cells(iter, "C").Value <> "" And _
             ActiveWorkbook.ActiveSheet.Cells(iter, "D").Value <> "" And _
              ActiveWorkbook.ActiveSheet.Cells(iter, "F").Value <> "" Then
            ActiveWorkbook.ActiveSheet.Cells(iter, "A").Interior.Color = RGB(220, 80, 20)
             ActiveWorkbook.ActiveSheet.Cells(iter, "C").Interior.Color = RGB(220, 80, 20)
              ActiveWorkbook.ActiveSheet.Cells(iter, "D").Interior.Color = RGB(220, 80, 20)
               ActiveWorkbook.ActiveSheet.Cells(iter, "F").Interior.Color = RGB(220, 80, 20)
        End If
    Next iter
End Sub