Hi,

I have the following code in my DBFToExcel procedure (written with the help of Cetin Basoz):

** Made the Totals row in bold and Green highlight
	loExcel.RANGE([A1], loExcel.SELECTION.SpecialCells(xlLastCell)).SELECT
	loExcel.SELECTION.FormatConditions.DELETE
	loExcel.SELECTION.FormatConditions.ADD(xlExpression,, '=UPPER(Left($A1,5))="TOTAL"')

	WITH loExcel.SELECTION.FormatConditions(1)
		.FONT.Bold = .T.
		.Interior.ColorIndex = 4
	ENDWITH

I found that it doesn't work in Excel 2007, e.g. the Totals are not highlighted with green color.

Do you know how to make this code work in this version?

Thanks in advance.