Highlight Active Row and Column.

Dear Friends,
I am looking for a formula for conditional formatting of whole Row and Column in different color when I select a cell. As I move from cell to cell this intersection of color bands should also move to next active cell. I have used the formula
=AND(CELL("row")=CELL("row",A1),CELL("col")>CELL("col",A1)) for ROW and
=AND(CELL("col")=CELL("col",A1),CELL("row")>CELL("row",A1)) for COLUMN
for rows and columns, it is working perfectly but its not highlighting whole row or column. what modification is required in formula?

Hi
Cut and paste this code behind the worksheet you will be working on, right-click the worksheet tab and select View Code, then paste the code below and close the window:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
Application.ScreenUpdating = False
' Clear the color of all the cells
Cells.Interior.ColorIndex = 0
With Target
' Highlight the entire row and column that contain the active cell
.EntireRow.Interior.ColorIndex = 8
End With
Application.ScreenUpdating = True
End Sub

Good luck.
Tony

Thanks Dear Tony,

I am looking for formula to be entered in Conditional Formatting. Using VBA code disable other formatting for warning which I do not want to part with.
Regards,

Hi
I am not aware of any method to highlight rows with Conditional Formatting, however I have found a link where you can download an add-in that will do the job for you. See this link:

http://www.cpearson.com/excel/RowLiner.htm

Good luck.
Tony