cell colour

[shrikant sinnur]

sir,
if i select g8 or any cell in work sheet it should colour vertically and horizontaly as we select.

 

[VoG]

Select the area that you want to apply this to, Format > Conditional Formatting, use Formula Is and enter the formula

=OR(ROW()=CELL("row"),COLUMN()=CELL("col"))

Click the Format button and apply a colour on the Fill tab and OK.

Right click the sheet tab, select View Code and paste in

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

then press ALT + Q to return to your sheet.

 

[sen_edp]

hi

go to this link


http://www.mrexcel.com/forum/showthread.php?t=14241

Ivan Moala did a very nice job....