Hi

I have used conditional formatting, by which cells in a column (Column D) would either have "Text1" or "Text2" or "Text3". Please suggest vb code so that macro runs a check on 'Column D' and if any cell contains "Text3", a pop-up appears with message "Text3 is there"

Thanx in advance