Highlighting column and row intersection cells?

[gaftalik]

Hi everybody,

Any code or formula to highlight the intersected cells between a column and a row for any selected cell ?

Ex: if i select E25 the cells of column E1:E25 as well as the cells of Row A25:E25 to be highlighted in a certain color , and so on for any selected cell..

Thank you much for your help .

 

[TheNoocH]

there is a More Colors button (at least on Excel 2007)...you can select any custom color...

 

[gaftalik]

I am using excel 2003 , is that possible too ?