Highlight Row AND Column of Active Cell

[HollyAnn73]

Is there a function that will allow for the active cell's row and column to be highlighted at the same time (while working)?

 

[Walky]

Me again

Yahya or Jaafar Tribak,

Is there a way to combine your codes so that Yahya's solution, which preserves the formatting, can also allow multiple selection as Jaafar's solution does?

And how about a custom macro button linked to the PERSONAL.XLS file that would allow you to enable/disable this function on any active worksheet?

Wouldn't it be great (in my dreams)?

Thx,

W.

 

[Yahya]

Hi Walky

to do the same steps in xl2003
1) Format Menu.
2) Choose Conditional Formating .
3)you will have Drop down list with "Cell Value Is " Change It to " Formula Is "
4) copy and paste the formula
=OR(CELL("row")=ROW(),CELL("col")=COLUMN())
5) choose your format
6) then Right click on sheet name --> View code , then paste this code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub

===========
Jaafar Tribak

it is long time without talking to you man

HTH