Yes Yes I know its possible. My TXT file is already delimite
automatically. Here's a partial code:

Selection.FormatConditions.DELETE
Selection.FormatConditions.Add Type:=xlCellValue
Operator:=xlNotEqual, _
Formula1:="=$AP$9"
Selection.FormatConditions(1).Interior.ColorIndex = 15

It basically copies the cell from one workbook and pastes it to anothe
then runs conditional formating and then delets the pasted cell.
What I want, through programming, is a way to skip the copy and past
procedure and just compare each cell and if not equal, make that cel
color gray (i cannot use red)

--
Message posted from http://www.ExcelForum.com