--------------------------------------------------------------------------------

This VBA & conditional formatting highlights the row & column of the cell you select in the sheet, quite useful when dealing with a lot of columns & rows.
I recognize the symptoms of my problem, in Excel 2003 if your VBA was messed up, the conditional formatting worked but you had to leave the worksheet and return for the formatting to update, this is what it is doing now but I cannot get the VBA and/or conditional formattine to cooperate in Excel

Steps I used to insert VBA:

Press Alt F11
locate file 　　　　
select MS Excel Objects
double click ThisWorkbook
left pull down menu - select workbook
right pull down - SheetSelectionChange
Add "Application.ScreenUpdating=true



VBA FORMULA SHOULD LOOK LIKE THIS
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = True
End Sub

Conditional Formatting steps I used:

SELECT WHOLE WORKSHEET FOR THIS CONDITIONAL FORMATTING FORMULA
FORMULA IS:
=OR(AND(CELL("row")=ROW(),COLUMN()<=CELL("col")),AND(CELL("col")=COLUMN(),ROW()<=CELL("row")))

Can anyone tell me why this will work in Excel 2003 and not in Excel 2007. I have repeatedly checked accuracy in both versions, no joy in the 2007 version.

Thanks in advance,
Mark