Conditional formatting based on multiple columns

[dougbee]

I need some help formatting items in column A depending if they are found in other columns. How do I do this?

 

[venkat1926]

try this macro (change the colorindex number as you wish)

Sub test()
Dim r As Range, c As Range, animal As String, cfind As Range
Set r = Range(Range("A1"), Range("A1").End(xlDown))
r.Interior.ColorIndex = xlNone
For Each c In r
animal = c
If WorksheetFunction.CountIf(Columns("E:E").Cells, animal) > 0 Then c.Interior.ColorIndex = 6
If WorksheetFunction.CountIf(Columns("d:d").Cells, animal) > 0 Then c.Interior.ColorIndex = 3
Next c
MsgBox "macro done"
End Sub

 

[Andrew Poulsom]

You can use a Conditional Formatting formula like:

=COUNTIF(D:D,A1)

 

[dougbee]

Thank you Andrew. That is what I was looking for!