Hey, guys. What's up?
I'd like to know if it's possible to do something like this...
1) I click or simply move the cursor to a certain cell, say, B10.
2) That cell (B10) gets highlighted (by highlighted, I mean, its background color gets changed into red, for instance).
3) I leave the cell (B10) by clicking or moving the cursor to another cell, say, B11.
4) The cell I left (B10) gets its formatting back; same cell formatting it had before I clicked on it.
teylyn has already helped me with something similar. Take a look, please.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim lrow As Long
On Error Resume Next
lrow = Range("A18").End(xlDown).Row
Application.ScreenUpdating = False
If Intersect(Target, Range("A18", Range("G" & lrow))) Is Nothing Then
Rows("18:" & lrow).RowHeight = 13.25
Else
Rows("18:" & lrow).RowHeight = 13.25
Target.RowHeight = 20
End If
Application.ScreenUpdating = True
End Sub
By the way, it's easy to do this when I already know the target cell formatting. However, if I have a big range of cells with different formatting, it's more complicated (to me, of course). That's why I want to know if it's possible to do it automatically for the whole formatting (background color, font color, borders, everything).
It would be something like... When I click a cell, Excel copies the formatting of that cell and then changes its background color (so it gets highlighted). Then, when I leave that cell, Excel pastes that formatting back on it.
I hope you can help. I really don't know how to do that.
Thank you very much for your attention, guys. 
brunces
Bookmarks